create table testTable (
id varchar(200) primary key not null,
testRecord varchar(200),
)
格式如右:execute sp_addextendedproperty \'MS_Description\',\'字段备注信息\',\'user\',\'dbo\',\'table\',\'字段所属的表名\',\'column\',\'添加注释的字段名\';
execute sp_addextendedproperty \'MS_Description\',\'添加的注释内容\',\'user\',\'dbo\',\'table\',\'testTable\',\'column\',\'testRecord\';
execute sp_updateextendedproperty \'MS_Description\',
\'修改的注释内容\',\'user\',\'dbo\',\'table\',\'testTable\',\'column\',\'testRecord\';
删除字段注释execute sp_dropextendedproperty \'MS_Description\',\'user\',\'dbo\',\'table\',\'testTable\',\'column\',\'testRecord\';
execute sp_addextendedproperty \'MS_Description\',\'注释-些表为测试表\',\'user\',\'dbo\',\'table\',\'testTable\',null,null;
execute sp_updateextendedproperty \'MS_Description\',\'修改注释-测试表\',\'user\',\'dbo\',\'table\',\'testTable\',null,null;
execute sp_dropextendedproperty \'MS_Description\',\'user\',\'dbo\',\'table\',\'testTable\',null,null;