SqlServer字段说明查询及快速查看表结构

发布时间：2020-12-12 13:44:15 所属栏目：MsSql教程来源：网络整理

导读：SqlServer字段说明查询 SELECT t. [ name ] AS 表名,c. AS 字段名, cast (ep. value ] as varchar ( 100 )) AS 字段说明 ] FROM sys.tables AS t INNER JOIN sys.columns AS c ON t. object_id = c. object_id LEFT JOIN sys.extended_properties AS ep ON e

SqlServer字段说明查询

复制代码

SELECT t.[name] AS 表名,c.AS 字段名,cast(ep.value] 
  as varchar(100)) AS 字段说明]
  FROM sys.tables AS t
  INNER JOIN sys.columns 
  AS c ON t.object_id = c.object_id
   LEFT JOIN sys.extended_properties AS ep 
  ON ep.major_id AND ep.minor_id = c.column_id WHERE ep.class =1 
  AND t.name='TableName'

复制代码

快速查看表结构

--快速查看表结构（比较全面的） SELECT CASE WHEN col.colorder = 1 THEN obj.name ELSE '' END AS 表名,col.colorder AS 序号,col.name AS 列名,ISNULL(ep.],0)">'') AS 列说明,t.name AS 数据类型,col.length AS 长度,255)">ISNULL(COLUMNPROPERTY(col.id,col.name,0)">Scale'),0) AS 小数位数,255)">WHEN IsIdentity') THEN √' '' AS 标识,255)">WHEN EXISTS ( SELECT 1 FROM dbo.sysindexes si JOIN dbo.sysindexkeys sik ON si.id = sik.id AND si.indid = sik.indid JOIN dbo.syscolumns sc ON sc.id AND sc.colid = sik.colid JOIN dbo.sysobjects so ON so.name = si.name AND so.xtype = PK' WHERE sc.id = col.id = col.colid ) AS 主键,255)">WHEN col.isnullable AS 允许空,255)">ISNULL(comm.text,255)">AS 默认值 FROM dbo.syscolumns col LEFT JOIN dbo.systypes t ON col.xtype = t.xusertype inner JOIN dbo.sysobjects obj ON col.id = obj.id AND obj.xtype U' AND obj.status >= 0 JOIN dbo.syscomments comm ON col.cdefault = comm.id JOIN sys.extended_properties ep = ep.major_id AND col.colid = ep.minor_id AND ep.name MS_Description' JOIN sys.extended_properties epTwo ON obj.id = epTwo.major_id AND epTwo.minor_id 0 AND epTwo.name ' WHERE obj.name '表名 ORDER BY col.colorder ;

复制代码

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!