首页 > 代码库 > sql server2008给数据表，字段，添加修改注释

sql server2008给数据表，字段，添加修改注释

2024-09-02 20:11:23   211人阅读

?
1
2
3
4
-- 表加注释
EXEC sys.sp_addextendedproperty @name=N‘MS_Description‘, @value=http://www.mamicode.com/N‘注释内容‘ , @level0type=N‘SCHEMA‘,@level0name=N‘dbo‘, @level1type=N‘TABLE‘,@level1name=N‘表名‘
--例如：
EXEC sys.sp_addextendedproperty @name=N‘MS_Description‘, @value=http://www.mamicode.com/N‘系统设置表‘ , @level0type=N‘SCHEMA‘,@level0name=N‘dbo‘, @level1type=N‘TABLE‘,@level1name=N‘CM01_SYSTEM‘

2、给表的“字段”添加注释

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
--新增数据字段注释
 
EXECUTE sp_addextendedproperty ‘MS_Description‘, ‘收益浮动表‘, ‘user‘, ‘dbo‘, ‘table‘, ‘COM_IncomeFloat‘, ‘column‘, ‘RowId‘;
 
--修改数据字段注释
EXECUTE sp_updateextendedproperty ‘MS_Description‘, ‘收益浮动表‘, ‘user‘, ‘dbo‘, ‘table‘, ‘COM_IncomeFloat‘, ‘column‘, ‘RowId‘;
 
MS_Description ：调用的Proc
COM_IncomeFloat ：表名
RowId ：表字段
 
--查询字段注释
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 = ‘COM_IncomeFloat‘

 

出处：http://www.cnblogs.com/Gold-fangjin/p/5900970.html

sql server2008给数据表，字段，添加修改注释


联系
我们