Apresentando informações de suas tabelas

Apresentando informações de suas tabelas

Este script apresenta todos os nomes de suas tabelas – junto com o nome das colunas,
tipos de dados, e se a coluna é null/not null, no banco de dados.

SELECT Sysobjects.name AS TABLE_NAME, syscolumns.Id, 
syscolumns.name AS COLUMN_NAME,
systypes.name AS DATA_TYPE, syscolumns.length as CHARACTER_MAXIMUM_LENGTH, 
sysproperties.[value] AS COLUMN_DESCRIPTION,  syscomments.text as
COLUMN_DEFAULT,syscolumns.isnullable as IS_NULLABLE FROM syscolumns
INNER JOIN systypes
    ON syscolumns.xtype = systypes.xtype 
LEFT JOIN sysobjects ON syscolumns.id = sysobjects.id 
LEFT OUTER JOIN sysproperties ON 
( sysproperties.smallid = syscolumns.colid
AND sysproperties.id = syscolumns.id) 
LEFT OUTER JOIN syscomments ON syscolumns.cdefault = syscomments.id 
    WHERE syscolumns.id IN  
(SELECT id FROM SYSOBJECTS WHERE xtype = 'U') AND (systypes.name <> 'sysname')
ORDER BY syscolumns.colid