gbase 字段注释comm_快速查看表结构 SQL server查看表注释以及字段注释表结构字段说明...

DECLARE @tableName NVARCHAR(MAX);

SET @tableName = N'UserIntegralExchange';   --表名!!!

SELECT CASE WHEN col.colorder = 1 THEN obj.name

ELSE ''

END AS 表名 ,

col.colorder AS 序号 ,

col.name AS 列名 ,

ISNULL(ep.[value], '') AS 列说明 ,

t.name AS 数据类型 ,

col.length AS 长度 ,

ISNULL(COLUMNPROPERTY(col.id, col.name, 'Scale'), 0) AS 小数位数 ,

CASE WHEN COLUMNPROPERTY(col.id, col.name, 'IsIdentity') = 1 THEN '√'

ELSE ''

END AS 标识 ,

CASE WHEN EXISTS ( SELECT 1

FROM dbo.sysindexes si

INNER JOIN dbo.sysindexkeys sik ON si.id = sik.id

AND si.indid = sik.indid

INNER JOIN dbo.syscolumns sc ON sc.id = sik.id

AND sc.colid = sik.colid

INNER JOIN dbo.sysobjects so ON so.name = si.name

AND so.xtype =