获取SQL 各字段说明，表名等有效信息

 

SELECT Sysobjects.name AS tablename, syscolumns.Id, syscolumns.name AS name,
systypes.name AS type, syscolumns.length as size,
sys.extended_properties.[value] AS columnDesc,  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 sys.extended_properties ON
  ( sys.extended_properties.minor_id = syscolumns.colid
    AND sys.extended_properties.major_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

转载于:https://www.cnblogs.com/yongheng178/archive/2010/11/04/1868832.html