T-Sql DB Table Column

• 读DBName

       SELECT TOP 100 PERCENT name AS DBName FROM dbo.sysdatabases ORDER BY name DESC

• 读DB Tables

      SELECT name AS tabelName FROM dbo.sysobjects WHERE (type = 'U') AND (name <> N'dtproperties') Order By tabelName

      -- V -》View

• 读Table 属性
      SELECT dbo.syscolumns.name AS ColumnName, dbo.systypes.name AS TypeName, dbo.syscolumns.length FROM dbo.syscolumns INNER JOIN dbo.sysobjects ON dbo.syscolumns.id = dbo.sysobjects.id INNER JOIN dbo.systypes ON dbo.syscolumns.xtype = dbo.systypes.xtype WHERE (dbo.sysobjects.name = '{0}') and (dbo.systypes.name <> N'sysname') Order By ColumnName

 

  引用：  http://blog.csdn.net/moonshineidolon/archive/2006/12/29/1467569.aspx