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

时间:2022-05-31 03:06:30

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

 1、sqlserver用语句给表注释

EXECUTE sp_addextendedproperty N'MS_Description', N'表注释', N'user', N'dbo', N'table', N'', NULL, NULL

2、sqlserver用语句给表的“字段”注释

EXECUTE sp_addextendedproperty N'MS_Description', N'字段注释', N'user', N'dbo', N'table', N'表名', N'column', N'字段名'

3、查看sqlserver注释

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 = '表名'

 

出处:http://begoodluck.blog.163.com/blog/static/20450728020141191412788/

===========================================================================

1、 给表添加注释

1234 --
表加注释
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'注释内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'表名'--例如:EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统设置表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CM01_SYSTEM'

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

1234567891011121314151617181920212223 --新增数据字段注释 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
:表字段
 --查询字段注释SELECTA.name AS table_name,B.name AS column_name,C.value AS column_descriptionFROM sys.tables AINNER JOIN sys.columns B ON B.object_id = A.object_idLEFT JOIN sys.extended_properties C ON C.major_id = B.object_id AND C.minor_id = B.column_idWHERE A.name 'COM_IncomeFloat'

 

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