[dba-SQLServer]UNION Columns?

select table_name, column_name, data_type, is_nullable,
character_maximum_length 
from information_schema.columns;

Try a select * to see what other goodies you can get!

--Susan


-----Original Message-----
From: Arthur Fuller [mailto:artful at rogers.com] 
Sent: Monday, May 05, 2003 1:52 PM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer]UNION Columns?


That works well, and thank you for that. Just one more question
(actually
two): where to get the column size and where to get the NOT NULL or
whatever?

A.

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Billy
Pang
Sent: May 5, 2003 2:11 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer]UNION Columns?


select table_name, column_name, data_type from
information_schema.columns;

HTH
Billy


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com