sql 输出表结构

最新推荐文章于 2021-12-18 13:19:43 发布

zf_missyou

最新推荐文章于 2021-12-18 13:19:43 发布

阅读量911

点赞数

CC 4.0 BY-SA版权

文章标签： sql join properties

本文链接：https://blog.csdn.net/zf_missyou/article/details/6997490

本文探讨了如何使用SQL查询语句从数据库中获取特定部门表的详细属性，包括字段名称、数据类型、占用字节、是否为空及说明。

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

select * into tablex from department where 1=1

Select a.name AS 字段名, b.name AS 类型,a.length as 占用字节数,(case when a.isnullable=1 then '√' else '' end)as 是否为空,(g.[value]) as 说明 FROM syscolumns a INNER JOIN systypes b ON a.xusertype = b.xusertype INNER JOIN sysobjects d ON a.id = d.id AND d.xtype = 'U' AND d.name <> 'dtproperties' left join sys.extended_properties g on a.id=g.major_id AND a.colid = g.minor_id Where (d.name = 'department') ORDER BY a.id