Add a table comment in SQL Server

Today after creating the table, found that there is no way to add comment notes to the table, the field comments can be added when the table, the Internet looked at the use of SQL to add comments to the table method, as follows:

--Table plus CommentsEXECSys.sp_addextendedproperty@name=N'ms_description',@value=N'Comment Content',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'Table name'--For example:EXECSys.sp_addextendedproperty@name=N'ms_description',@value=N'System Setup table',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'Cm01_system'

By the way, note the method of adding comments to a table's fields using SQL as follows:

1 --field plus Comment2 EXECSys.sp_addextendedproperty@name=N'ms_description',@value=N'Comment Content',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'Table name',@level2type=N'COLUMN',@level2name=N'Field name'

Add a table comment in SQL Server