1.我的表
[id],[name],[type],[date]四个字段,,,表名是library
<h1>2.添加列描述</h1>
姓名:描述信息
library:表名
被描述字段:name
EXECUTE sp_addextendedproperty N'MS_Description', '姓名', N'user', N'dbo', N'table', N'library', N'column', N'name'
name字段添加"姓名"描述信息
<h1>3.删除描述</h1>
library:表名
name:有描述信息的字段
EXEC sp_dropextendedproperty 'MS_Description','user',dbo,'table','library','column',name
<h1>4.查看描述情况</h1>
library:要查看的表(查出该表的所有字段描述信息)
SELECT
A.name AS table_name,
B.name AS column_name,
C.value AS column_description
FROM sys.tables A
INNER JOIN sys.columns B ON B.object_id = A.object_id
LEFT JOIN sys.extended_properties C ON C.major_id = B.object_id AND C.minor_id = B.column_id
WHERE A.name = 'library'
摘自:https://www.cnblogs.com/wangshenhe/p/3178039.html
