- SELECT sys.sysobjects.name AS 表名, sys.syscolumns.name AS 字段名, CASE WHEN systypes.name IN ('binary', 'char', 'nchar') THEN (systypes.name + '(' + CAST(syscolumns.prec AS varchar(50)) + ')')
- WHEN systypes.name IN ('decimal', 'numeric') THEN (systypes.name + '(' + CAST(syscolumns.prec AS varchar(50)) + ',' + CAST(syscolumns.scale AS varchar(50)) + ')')
- WHEN systypes.name IN ('nvarchar', 'varchar', 'varbinary') THEN (CASE WHEN syscolumns.prec = - 1 THEN (systypes.name + '(MAX)')
- ELSE (systypes.name + '(' + CAST(syscolumns.prec AS varchar(50)) + ')') END) ELSE systypes.name END AS 字段类型, sys.syscomments.text AS 默认值,
- CASE WHEN syscolumns.isnullable = 1 THEN 'Y' ELSE 'N' END AS 能否为空, CAST(sys.extended_properties.value AS varchar(1024)) AS 备注
- FROM sys.syscolumns INNER JOIN
- sys.systypes ON sys.syscolumns.xtype = sys.systypes.xtype LEFT OUTER JOIN
- sys.sysobjects ON sys.syscolumns.id = sys.sysobjects.id LEFT OUTER JOIN
- sys.extended_properties ON sys.extended_properties.minor_id = sys.syscolumns.colid AND sys.extended_properties.major_id = sys.syscolumns.id LEFT OUTER JOIN
- sys.syscomments ON sys.syscolumns.cdefault = sys.syscomments.id
- WHERE (sys.syscolumns.id IN
- (SELECT id
- FROM sys.sysobjects AS sysobjects_1
- WHERE (xtype = 'u'))) AND (sys.systypes.name <> 'sysname')
- ORDER BY 表名
准确的来说我根本记不得从×××到的这个了
只记得是很久很久以前从一个诡异的网页上找到的
还是发上来一下吧
如果你觉得侵犯了你的权益请联系我删除该文章
转载于:https://blog.51cto.com/starry/293952