Add comments to SQL Server table

sp_addextendedproperty 'BackColor', 'Red', 'user', '<schema name>', 'table', '<table name>', 'column', '<column name>'.

-- Create comment for TABLE
DECLARE @CurrentUser sysname
SELECT @CurrentUser = user_name()
EXEC sp_addextendedproperty 'MS_Description',
   'This is comment for table_one',
   'USER', @CurrentUser, 'TABLE', 'table_one';

-- Create comment for COLUMN within TABLE
EXEC sp_addextendedproperty 'MS_Description',
   'This is comment for column_one in table_one',
   'USER', @CurrentUser, 'TABLE', 'table_one', 'COLUMN', 'column_one';