Help with Query -- sql server mseq

Hugo Kornelis
4/21/2004 10:24:17 PM

[quoted text, click to view]

Hi Dave,

Try the following:

SELECT TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS

Best, Hugo
--

Dave Lugo
4/22/2004 4:09:35 PM

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

[quoted text, click to view]

Hugo Kornelis
4/23/2004 9:43:48 AM

[quoted text, click to view]
Hi Dave,

There are many more columns in the INFORMATION_SCHEMA.COLUMNS view. If
you use SELECT *, you'll see them all and you can check which you need
and which you don't need.

Alternatively, consult Books Online for more information on this view
(as well as other INFORMATION_SCHEMA-views).

Best, Hugo
--

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server mseq

sql server mseq : Help with Query