SQL Server adds comments to tables and fields

First, table

1. Add Table annotations

EXECUTESys.sp_addextendedproperty@name =N'ms_description',--sysname    @value =N'Dictionary Group Table',--sql_variant    @level0type =N'User',--varchar (+)    @level0name =N'Base',--sysname Schema    @level1type =N'Table',--varchar (+)    @level1name =N'Tbldictionarygroup',--sysname    @level2type = NULL,--varchar (+)    @level2name = NULL --sysname

2. Modify the Table notes

EXECUTESys.sp_updateextendedproperty@name =N'ms_description',--sysname    @value =N'Dictionary Group table 1',--sql_variant    @level0type =N'User',--varchar (+)    @level0name =N'Base',--sysname Schema    @level1type =N'Table',--varchar (+)    @level1name =N'Tbldictionarygroup',--sysname    @level2type = NULL,--varchar (+)    @level2name = NULL --sysname

3. Delete Table annotations

 EXECUTESys.sp_dropextendedproperty@name =N'ms_description',--sysname    @level0type =N'User',--varchar (+)    @level0name =N'Base',--sysname Schema    @level1type =N'Table',--varchar (+)    @level1name =N'Tbldictionarygroup',--sysname    @level2type = NULL,--varchar (+)    @level2name = NULL --sysname

Second, Column

1. Add Field comments

SQL Server adds comments to tables and fields