Thanks Patrick that helped a lot.

-----Original Message-----
From: Patrick Gallucci [mailto:[Email Address Removed]
Sent: Saturday, January 25, 2003 11:28 AM
To: LazyDBA.com Discussion
Subject: RE: I need a script

Do some research on INFORMATION_SCHEMA...this should get you started...

SELECT *
FROM INFORMATION_SCHEMA.Tables T JOIN INFORMATION_SCHEMA.Columns C
ON T.TABLE_NAME = C.TABLE_NAME
WHERE T.TABLE_NAME NOT LIKE 'sys%'
AND T.TABLE_NAME <> 'dtproperties'
AND T.TABLE_SCHEMA <> 'INFORMATION_SCHEMA'
ORDER BY T.TABLE_NAME, C.ORDINAL_POSITION


-----Original Message-----
From: Rob DeMotsis [mailto:[Email Address Removed]
Sent: Saturday, January 25, 2003 10:53 AM
To: LazyDBA.com Discussion
Subject: I need a script


Does anyone have a script that will loop through all tables in a
database and return table, column name, datatype. Or can anyone give me
a starting point. TSQL person I am not but I am learning. Thanks.

Rob DeMotsis
Lead DBA


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page