Apresentando informações de suas tabelas

Apresentando informações de suas tabelas
<SPAN ><BR>Este script apresenta todos os nomes de suas tabelas – junto com o nome das colunas, <BR>tipos de dados, e se a coluna é null/not null, no banco de dados.</FONT></FONT></SPAN>

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