查询表结构sql
2024-09-06 05:12:58
SELECT CASE WHEN col.colorder = 1 THEN obj.name ELSE '' END AS 表名, col.colorder AS 序号, col.name AS 列名,
ISNULL(ep.value, N'') AS 列说明, t.name AS 数据类型, col.length AS 长度, ISNULL(COLUMNPROPERTY(col.id, col.name,
'Scale'), 0) AS 小数位数, CASE WHEN COLUMNPROPERTY(col.id, col.name, 'IsIdentity')
= 1 THEN '√' ELSE '' END AS 标识, CASE WHEN EXISTS
(SELECT 1
FROM dbo.sysindexes si INNER JOIN
dbo.sysindexkeys sik ON si.id = sik.id AND si.indid = sik.indid INNER JOIN
dbo.syscolumns sc ON sc.id = sik.id AND sc.colid = sik.colid INNER JOIN
dbo.sysobjects so ON so.name = si.name AND so.xtype = 'PK'
WHERE sc.id = col.id AND sc.colid = col.colid) THEN '√' ELSE '' END AS 主键,
CASE WHEN col.isnullable = 1 THEN '√' ELSE '' END AS 允许空, ISNULL(comm.text, N'') AS 默认值
FROM syscolumns AS col LEFT OUTER JOIN
systypes AS t ON col.xtype = t.xusertype INNER JOIN
sysobjects AS obj ON col.id = obj.id AND obj.xtype = 'U' AND obj.status >= 0 LEFT OUTER JOIN
syscomments AS comm ON col.cdefault = comm.id LEFT OUTER JOIN
sys.extended_properties AS ep ON col.id = ep.major_id AND col.colid = ep.minor_id AND
ep.name = 'MS_Description' LEFT OUTER JOIN
sys.extended_properties AS epTwo ON obj.id = epTwo.major_id AND epTwo.minor_id = 0 AND
epTwo.name = 'MS_Description'
WHERE (obj.name = 'TB_ROOM_STATE')
ORDER BY 序号
最新文章
- ui-router带参数的ui-sref配置
- Android 中的 Service 全面总结
- NOIP“对偶”题:还教室
- C#集合 -- 自定义集合与代理
- 阿里云yum源
- 《Genesis-3D开源游戏引擎完整实例教程-跑酷游戏篇:简介及目录》(附上完整工程文件)
- BZOJ 1688: [Usaco2005 Open]Disease Manangement 疾病管理
- javascript朝花夕拾
- C单链表实现
- java学习之实现文件的复制
- HDU 4739 求正方形个数
- Python assert(断言)
- spring 总结
- Python常见下划线
- 模仿以太坊 ERC20 规范的 Hyperledger Fabric 实现 Token 通证
- jquer文字闪烁简单实现
- Windows下docker的安装,将ASP.NET Core程序部署在Linux和Docker中
- Putty建立隧道的方法[z]
- Loj10086 Easy SSSP
- 读写SQLServer数据库中的image类型数据(简单)