sql server用SQL语句查看字段说明
2024-09-05 06:33:44
SELECT t.[name] AS 表名,c.[name] AS 字段名,cast(ep.[value]
as varchar()) AS [字段说明]
FROM sys.tables AS t
INNER JOIN sys.columns
AS c ON t.object_id = c.object_id
LEFT JOIN sys.extended_properties AS ep
ON ep.major_id = c.object_id AND ep.minor_id = c.column_id WHERE ep.class =
AND t.name='表名'
最新文章
- 前端CSS预处理器Sass
- Linux C 收藏
- C#中用radio单选Repeater循环数据,js实现
- Docker configure http proxy
- JAVA package-info文件【转】
- Integer Inquiry -TJU1112
- 赋值容器winform 根据NAME查找控件
- Linux调试工具strace和gdb常用命令小结
- js表格排序 &; 去除字符串空格
- CentOS常用到的查看系统命令
- 拥抱.NET Core系列:依赖注入(2)
- Firefox Profile
- LeetCode算法题-Quad Tree Intersection(Java实现)
- 找不到类SimpleJdbcTemplate ParameterizedRowMapper cannot be resolved
- Intellij添加Jetty远程Debug
- 基于ngx_lua的动态服务路由方案
- Logstash 报错 An unexpected error occurred! :error =>; bad URI(is not URI?,是因为路径c:\program files\logstash\logstash.bat 中有空格
- PowerDesigner使用技巧(转载)
- 9.5Django操作数据库的增删改查
- centos7 安装java和tomcat9