本文介绍了一种使用T-SQL查询SQL Server中指定表的元数据的方法，包括字段名、长度、数据类型、字段说明及是否允许为空等信息。
Declare @tableName varchar(50)
Set @tableName = '表名'
select syscolumns.name as 字段名, syscolumns.length as 长度, systypes.name as '数据类型', sys.extended_properties.[value] AS '字段说明',syscolumns.isnullable as '是否允许空值' from syscolumns join systypes on syscolumns.xtype=systypes.xtype and systypes.name <> 'sysname' LEFT OUTER JOIN sys.extended_properties ON ( sys.extended_properties.minor_id = syscolumns.colid AND sys.extended_properties.major_id = syscolumns.id) where syscolumns.id in (select id from sysobjects where name= @tableName)
Set @tableName = '表名'
select syscolumns.name as 字段名, syscolumns.length as 长度, systypes.name as '数据类型', sys.extended_properties.[value] AS '字段说明',syscolumns.isnullable as '是否允许空值' from syscolumns join systypes on syscolumns.xtype=systypes.xtype and systypes.name <> 'sysname' LEFT OUTER JOIN sys.extended_properties ON ( sys.extended_properties.minor_id = syscolumns.colid AND sys.extended_properties.major_id = syscolumns.id) where syscolumns.id in (select id from sysobjects where name= @tableName)
扫一扫
83
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
