sql2008导出表的字典结构

最新推荐文章于 2022-11-04 11:16:37 发布

原创最新推荐文章于 2022-11-04 11:16:37 发布 · 493 阅读

0 ·

CC 4.0 BY-SA版权

Sql 专栏收录该内容

0 篇文章

订阅专栏

本文介绍了一组SQL查询语句，用于从SQL Server数据库中获取表的详细信息，包括字段名称、数据类型、长度、是否为主键等元数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

select * from sysobjects where xtype='u'
select * from syscolumns where id='34099162'
select * from sysproperties where TableID=34099162
select * from syscomments 
select * from systypes

select 'ID'=a.colorder,
'字段名称'=a.name,
'数据类型'=c.name,
a.xtype,
'长度'= COLUMNPROPERTY(a.id,a.name,'PRECISION'),
'标识' = case when COLUMNPROPERTY(a.id,a.name,'IsIdentity')=1 then '√'else '' end,
'主键' = case when exists(SELECT 1 FROM sysobjects where xtype='PK' and parent_obj=a.id and name in (
SELECT name FROM sysindexes WHERE indid in(
SELECT indid FROM sysindexkeys WHERE id = a.id AND colid=a.colid))) then '√' else '' end,
'允许空'=case when a.isnullable=1 then '√'else '' end,
'默认值' = isnull(d.text,''),
'备注' = b.PropValue
from syscolumns a 
left join sysproperties b on a.name=b.ColName and a.id=b.TableID
left join systypes c on c.xtype=a.xtype
left join syscomments d on a.cdefault=d.id 
left join sysobjects e on e.id=a.id 
where e.name='Fl_Users' order by 1