Re: Help with Query

From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 04/23/04 

Date: Fri, 23 Apr 2004 09:43:48 +0200

On Thu, 22 Apr 2004 16:09:35 -0700, Dave Lugo wrote:

>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
>
>
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 

-- 
(Remove _NO_ and _SPAM_ to get my e-mail address)