本文提供了一种查询SQL Server中特定表（hr_users）的详细结构的方法，包括字段名、数据类型、是否允许为空等信息，并附带了获取每个字段描述的额外查询。
-
select table_name from INFORMATION_SCHEMA.TABLES
-
SELECT dbo.syscolumns.name, dbo.syscolumns.colid AS columnID,dbo.sysobjects.ID AS TableID, dbo.systypes.name as DataType,case when dbo.syscolumns.autoval is not null then 1 else 0 end isautoval, dbo.syscolumns.prec ,dbo.syscolumns.isnullable ,dbo.syscolumns.scale,dbo.sysproperties.[value] AS Description FROM dbo.systypes RIGHT OUTER JOIN dbo.syscolumns ON dbo.systypes.xtype = dbo.syscolumns.xtype LEFT OUTER JOIN dbo.sysproperties ON dbo.syscolumns.id = dbo.sysproperties.id AND dbo.syscolumns.colid = dbo.sysproperties.smallid RIGHT OUTER JOIN dbo.sysobjects ON dbo.syscolumns.id = dbo.sysobjects.id WHERE systypes.xtype = systypes.xusertype and (dbo.sysobjects.xtype = 'u') AND (dbo.systypes.status <> 1) AND (dbo.sysobjects.id <> 1977058079) and dbo.sysobjects.name='hr_users' order by dbo.syscolumns.colid
-
SELECT dbo.syscolumns.name as name, dbo.sysproperties.[value] AS Description FROM dbo.syscolumns LEFT OUTER JOIN dbo.sysproperties ON dbo.syscolumns.id = dbo.sysproperties.id AND dbo.syscolumns.colid = bo.sysproperties.smallid RIGHT OUTER JOIN dbo.sysobjects ON dbo.syscolumns.id = dbo.sysobjects.id WHERE (dbo.sysobjects.xtype = 'u') AND (dbo.sysobjects.id <> 1977058079) and dbo.sysobjects.name='hr_users'<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
The sql statement of geting data about table config in SQL Server
最新推荐文章于 2021-01-27 17:26:19 发布
扫一扫
520
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
