备注 | 修改日期 | 修改人 |
其他原因...添加关联知识 | 2022-04-13 11:31:55[当前版本] | 系统管理员 |
CREAT | 2022-04-13 11:30:18 | 系统管理员 |
转自:http://www.360doc.com/content/18/0312/16/8463843_736400228.shtml
--快速查看表结构(字段、数据类型及字段说明)
declare @tablename nvarchar(30)
set
@tablename='SYS_HUM' --输入表名称
SELECT col.colorder AS 序号,
col.name AS 列名,
case when col.xtype=240 then 'geography'
when
t.name='nvarchar' then
t.name+'('+convert(nvarchar(10),col.length/2)+')'
when
t.name='varchar' then
t.name+'('+convert(nvarchar(10),col.length/2)+')'
when
t.name='decimal' then
t.name+'('+convert(nvarchar(10),col.xprec)+','+convert(nvarchar(10),col.xscale)+')'
else t.name
end AS 数据类型,
col.length as
长度,
ISNULL(ep.[value], '') 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
LEFT
JOIN dbo.syscomments comm ON col.cdefault = comm.id
LEFT
JOIN sys.extended_properties ep ON col.id = ep.major_id AND
col.colid = ep.minor_id AND ep.name = 'MS_Description'
LEFT JOIN sys.extended_properties epTwo ON obj.id =
epTwo.major_id AND epTwo.minor_id = 0 AND epTwo.name =
'MS_Description'
WHERE obj.name =@tablename
AND col.name
in ('exttextfield27','exttextfield28') --查看指定字段类型
ORDER BY
col.colorder;