Post reply

Drop extended property

  • September 27, 2008 at 9:31 am

    #191428

    Is there an sample script to drop the "MS_Description" of all tables and

    all columns in my database using cursor.

    Thanks in advance

  • September 27, 2008 at 3:07 pm

    #878094

    You can obtain a list of all defined extended properties by querying

    sys.extended_properties catalog view and insert that into a cursor as you seem to want to do. (Please read the description of each column contained in sys.extended_properties), armed with that information you should be able to write the necessary T-SQL to perform the deletion using sp_dropextendedproperty

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

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

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