2007 3:23 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: OT: SQL Server Schema
Thanks Rod. Thats a great start.
Brian
_
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Rod Higgins
Sent: Monday, 19 March 2007 2:17 PM
To: cfaussie@googlegroups.com
Subject
Thanks Rod. Thats a great start.
Brian
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of Rod Higgins
Sent: Monday, 19 March 2007 2:17 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: OT: SQL Server Schema
SELECT T.TABLE_NAME AS
SELECT T.TABLE_NAME AS [Table], C.COLUMN_NAME AS [Column],
C.IS_NULLABLE AS [Nulls], C.DATA_TYPE AS [Type]
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 <> '
