gpt4 book ai didi

获取MSSQL数据字典的SQL语句

转载 作者:qq735679552 更新时间:2022-09-29 22:32:09 24 4
gpt4 key购买 nike

CFSDN坚持开源创造价值,我们致力于搭建一个资源共享平台,让每一个IT人在这里找到属于你的精彩世界.

这篇CFSDN的博客文章获取MSSQL数据字典的SQL语句由作者收集整理,如果你对这篇文章有兴趣,记得点赞哟.

代码如下

CREATE VIEW dbo.vw_db_dictionary  AS  SELECT TOP 100 PERCENT dbo.sysobjects.name AS table_name,  dbo.sysproperties.[value] AS table_desc, dbo.syscolumns.name AS field,  properties.[value] AS field_desc, dbo.systypes.name AS field_type,  dbo.syscolumns.length AS field_size,  ISNULL(COLUMNPROPERTY(dbo.syscolumns.id, dbo.syscolumns.name, 'Scale'), 0)  AS field_precision, dbo.syscolumns.isnullable AS nullable,  CASE WHEN syscomments.text IS NULL  THEN '' ELSE syscomments.text END AS default_value,  CASE WHEN COLUMNPROPERTY(syscolumns.id, syscolumns.name, 'IsIdentity')  = 1 THEN '√' ELSE '' END AS is_identity, CASE WHEN EXISTS  (SELECT 1  FROM sysobjects  WHERE xtype = 'PK' AND name IN  (SELECT name  FROM sysindexes  WHERE indid IN  (SELECT indid  FROM sysindexkeys  WHERE id = syscolumns.id AND colid = syscolumns.colid)))  THEN '√' ELSE '' END AS is_key  FROM dbo.syscolumns INNER JOIN  dbo.sysobjects ON dbo.sysobjects.id = dbo.syscolumns.id INNER JOIN  dbo.systypes ON dbo.syscolumns.xtype = dbo.systypes.xtype LEFT OUTER JOIN  dbo.sysproperties properties ON dbo.syscolumns.id = properties.id AND  dbo.syscolumns.colid = properties.smallid LEFT OUTER JOIN  dbo.sysproperties ON dbo.sysobjects.id = dbo.sysproperties.id AND  dbo.sysproperties.smallid = 0 LEFT OUTER JOIN  dbo.syscomments ON dbo.syscolumns.cdefault = dbo.syscomments.id  WHERE (dbo.sysobjects.xtype = 'U')  ORDER BY dbo.sysobjects.name 。

最后此篇关于获取MSSQL数据字典的SQL语句的文章就讲到这里了,如果你想了解更多关于获取MSSQL数据字典的SQL语句的内容请搜索CFSDN的文章或继续浏览相关文章,希望大家以后支持我的博客! 。

24 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com