查询表的脚本

最新推荐文章于 2023-07-18 16:24:53 发布

weixin_30610755

最新推荐文章于 2023-07-18 16:24:53 发布

阅读量101

点赞数

原文链接：http://www.cnblogs.com/kingge/p/10138951.html

版权

SELECT C.column_id AS 序号,C.[name] AS 列名,S.[name] AS 类型,C.max_length AS 长度,C.scale AS 精度,P.[value] AS 字段描述,C.collation_name as 排序规则 
FROM SYS.tables AS T 
INNER JOIN SYS.columns AS C 
ON T.object_id=C.object_id 
INNER JOIN SYS.TYPES AS S 
ON C.user_type_id=S.user_type_id left join sys.extended_properties P
ON P.major_id=T.[object_id]
AND P.minor_id=C.column_id  
WHERE T.[name]='TA_WEBUserRegist' AND P.[name]='MS_Description';

转载于:https://www.cnblogs.com/kingge/p/10138951.html