Drop extended property

• vision59

  SSCrazy

  Points: 2601

  More actions

  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

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  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]