SQL Server添加字段注释，添加表注释comments
在SQL Server语法中，给表字段与表添加注释与Oracle语法有的很大的区别。
Oracle语法添加字段注释
语法
COMMENT on column 表.字段 is '字段注释';COMMENT ON table 表 IS '表注释';
示例
--添加userTest表的userName字段注释为"用户姓名"COMMENT on column userTest.userName is '用户姓名';--添加userTest表的表注释为"用户信息表"COMMENT ON table userTest IS '用户信息表';--对于删除、更新注释语法一样，直接更改即可。--删除userTest表的userName字段注释COMMENT on column userTest.userName is '';--删除userTest表的表注释COMMENT ON table userTest IS '';
Sql Server语法添加字段注释
语法
--添加字段注释execute sp_addextendedproperty 'MS_Description','填写你的字段注释','user','DB schema','table','填写表名','column','字段名';--修改字段注释execute sp_updateextendedproperty 'MS_Description','填写你的字段注释','user','DB schema','table','填写表名','column','字段名';--删除字段注释execute sp_dropextendedproperty 'MS_Description','user','DB schema','table','填写表名','column','字段名';-- 添加表注释execute sp_addextendedproperty 'MS_Description','填写你的表注释','user','DB schema','table','填写表名',null,null;-- 修改表注释execute sp_updateextendedproperty 'MS_Description','填写你的表注释','user','DB schema','table','填写表名',null,null;-- 删除表注释execute sp_dropextendedproperty 'MS_Description','user','DB schema','table','填写表名',null,null;
示例
--字段注释处理--添加dbo下的userTest表的userName字段注释为"用户名"execute sp_addextendedproperty 'MS_Description','用户名','user','dbo','table','userTest','column','userName';--修改dbo下的userTest表的userName字段注释为"xxx"execute sp_updateextendedproperty 'MS_Description','xxx','user','dbo','table','userTest','column','userName';--删除dbo下的userTest表的userName字段注释execute sp_dropextendedproperty 'MS_Description','user','dbo','table','userTest','column','userName';---表注释处理-- 添加dbo下的userTest表注释为"用户信息测试表"execute sp_addextendedproperty 'MS_Description','用户信息测试表','user','dbo','table','userTest',null,null;-- 修改dbo下的userTest表注释为"xxxxx"execute sp_updateextendedproperty 'MS_Description','xxxxx','user','dbo','table','userTest',null,null;-- 删除dbo下的userTest表注释execute sp_dropextendedproperty 'MS_Description','user','dbo','table','userTest',null,null;
