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