SQL SERVER添加表注释、字段注释
在这里插入代码片
execute sp_addextendedproperty 'MS_Description', '表备注内容', 'SCHEMA', 'dbo','table', '表名',NULL,NULL;
execute sp_updateextendedproperty 'MS_Description','表备注内容','user','dbo','table','表名',NULL,NULL;
execute sp_addextendedproperty 'MS_Description','字段备注内容','user','dbo','table','字段表名','column','字段名';
execute sp_updateextendedproperty 'MS_Description','字段备注内容','user','dbo','table','字段表名','column','字段名';
SELECT * FROM SYS.TABLES;
SELECT * FROM SYS.EXTENDED_PROPERTIES;
SELECT * FROM SYS.EXTENDED_PROPERTIES T WHERE T.MINOR_ID=0;
SELECT CAST(T.NAME AS VARCHAR) AS TABLE_NAME,
CAST(T1.VALUE AS VARCHAR) AS TABLE_DESCRIPTION
FROM SYS.TABLES T
LEFT JOIN SYS.EXTENDED_PROPERTIES T1 ON T.OBJECT_ID = T1.MAJOR_ID
AND T1.MINOR_ID = 0
ORDER BY T.NAME
![在这里插入图片描述](https://img-blog.csdnimg.cn/0ada4b6fc9684f96a45a86a9323937bb.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA57qi54mb5LiN5piv5ZWl,size_18,color_FFFFFF,t_70,g_se,x_16#pic_center)