Post reply

How to update a table''s column description

  • May 9, 2006 at 2:40 pm

    #112744

    Hi All,

    Is there a system stored procedure for updating the description on a column? In other words, how do you update the value in sysproperties.values for a particular column. I would like to automate the creation of tables (including descriptions) just using T-SQL.

    I looked at extended properties but that seems to be like creating your own description column (or some special values), but I want to use the existing "description".

    Thanks!

  • May 9, 2006 at 2:48 pm

    #636891

    You'll need to use the extended properties, and yes, it is like creating your own "description" column, but that's what you're doing when you add a description through the GUI, too, even though it's transparent to the user.

    See more here.

  • May 9, 2006 at 3:00 pm

    #636894

    That does the trick! Thank You.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply