Re: Help with Query

From: Dave Lugo (anonymous_at_discussions.microsoft.com)
Date: 04/22/04 

Date: Thu, 22 Apr 2004 16:09:35 -0700

Thanks. That worked out great.

What would I need to add to get the properties of the
column . ie. TABLE_NAME (numeric (10,0), Not Null

Thanks

>-----Original Message-----
>On Wed, 21 Apr 2004 12:35:42 -0700, Dave Lugo wrote:
>
>>I need help in generating a query that will give me all
>>my DB tables and associated columns.
>>
>>Thanks
>
>Hi Dave,
>
>Try the following:
>
>SELECT TABLE_NAME, COLUMN_NAME
>FROM INFORMATION_SCHEMA.COLUMNS
>
>
>Best, Hugo
>--
>
>(Remove _NO_ and _SPAM_ to get my e-mail address)
>.
>