Add Table Level Comment

Posted: January 6, 2009 in SQL Server 2005

To add a comment for a table, open a new query window and execute the following line of code:

-- Insert table for <TableName>
EXEC sys.sp_addextendedproperty
     @name       = N'MS_Description'
    ,@value      = N''
    ,@level0type = N'SCHEMA'
    ,@level0name = N'dbo'
    ,@level1type = N'TABLE'
    ,@level1name = N'';
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s