sql server2008给数据表，字段，添加修改注释 |
您所在的位置：网站首页 › description注释 › sql server2008给数据表，字段，添加修改注释 |
|
一、sqlserver用语句给表注释 html EXECUTE sp_addextendedproperty N'MS_Description', N'表注释', N'user', N'dbo', N'table', N'表名', NULL, NULLsql 二、sqlserver用语句给表的“字段”注释 sqlserver EXECUTE sp_addextendedproperty N'MS_Description', N'字段注释', N'user', N'dbo', N'table', N'表名', N'column', N'字段名'post 三、查看sqlserver注释spa 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 = '表名'code
出处：http://begoodluck.blog.163.com/blog/static/20450728020141191412788/server ===========================================================================htm 一、 给表添加注释 ? 1 2 3 4 -- 表加注释 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' 二、给表的“字段”添加注释 ? 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.htmlblog |
今日新闻 |
推荐新闻 |
| CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |