Post reply

Help With Query

  • July 13, 2005 at 10:14 am

    #61622

    I need to write a query against system tables to see what columns exist on what tables. It is rahter easy to get alist of the columns. I need some help knowing which tables they go with.

    Any assistance would be appreciated.

  • July 13, 2005 at 10:25 am

    #574011

    Select * from Information_schema.columns where table_name = 'TableName'

  • July 13, 2005 at 10:25 am

    #574009

    select * from information_schema.columns

  • July 13, 2005 at 10:26 am

    #574012

    ok, ok, I'll give you my vote if you insist.. Send the t-shirt at the same adress as all the books I ordered .

  • July 13, 2005 at 7:09 pm

    #574215

    Or this...

    select * from information_schema.columns

    where table_name like 'sys%'

    order by table_name, ordinal_position







    **ASCII stupid question, get a stupid ANSI !!!**

  • July 13, 2005 at 9:33 pm

    #574234

    He needs to query the system tables... not to get their columns info .

  • July 14, 2005 at 5:27 am

    #574307

    ok - then this:

    select * from information_schema.columns

    where table_name not like 'sys%'

    order by table_name, ordinal_position







    **ASCII stupid question, get a stupid ANSI !!!**

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply