- 当前位置：首页 >探索 >数据库干货：整理SQL Server非常实用的脚本
数据库干货：整理SQL Server非常实用的脚本
发布时间：2025-11-05 08:43:08 来源：技术快报 作者：人工智能
复制SELECT obj.name 表名,数据实用 col.colorder AS 序号 , col.nameAS 列名 , ISNULL(ep.[value], ) AS 列说明 , t.nameAS 数据类型 , CASEWHEN col.isnullable = 1 THEN1 ELSE ENDAS 允许空 , ISNULL(comm.text, ) AS 默认值, Coalesce(epTwo.value, ) AS documentation FROM dbo.syscolumns col LEFTJOIN dbo.systypes t ON col.xtype = t.xusertype innerJOIN dbo.sysobjects obj ON col.id = obj.id AND obj.xtype = U AND obj.status >= 0 LEFTJOIN dbo.syscomments comm ON col.cdefault = comm.id LEFTJOIN sys.extended_properties ep ON col.id = ep.major_id AND col.colid = ep.minor_id AND ep.name = MS_Description LEFTJOIN sys.extended_properties epTwo ON obj.id = epTwo.major_id AND epTwo.minor_id = 0 AND epTwo.name = MS_Description WHERE obj.namein( SELECT ob.name FROM sys.objects AS ob LEFTOUTERJOIN sys.extended_properties AS ep ON ep.major_id = ob.object_id AND ep.class = 1 AND ep.minor_id = 0 WHERE ObjectProperty(ob.object_id, IsUserTable) = 1 ) ORDERBY obj.name ; 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.
香港云服务器企商汇IT技术网源码库益华科技源码下载亿华云服务器租用IT资讯网益华IT技术论坛码上建站科技前瞻全栈开发极客编程益强编程堂智能时代亿华互联码力社亿华云计算汇智坊思维库运维纵横云站无忧云智核编程之道创站工坊亿华智慧云IT资讯网亿华灵动亿华科技益强智未来益华科技益强IT技术网益强科技技术快报多维IT资讯极客码头亿华云益强科技益强数据堂益强前沿资讯亿华智造
- Copyright © 2025 Powered by 数据库干货：整理SQL Server非常实用的脚本,技术快报 滇ICP备2023006006号-46sitemap