Menu
How to drop all extended properties on SQL Server in a scriptable way?
825
Example of Creating Extended Properties To look at the Extended Properties for a column, in SSMS expand Tables, find the table we created and then expand the Columns. Then right click on column "sno" and select Properties and go to the Extended Properties page.
Extended Properties are a way to create a self-documenting database. Extended Properties in SQL Server allows us to create additional customized properties to store additional information. Extended Properties are a way to create a self-documenting database. Every Extended Property has a user defined name and value.
You can't delete a column that has PRIMARY KEY or FOREIGN KEY constraints or other dependencies except when using the Table Designer in SSMS. When using Object Explorer or Transact-SQL, you must first remove all dependencies on the column.
Please see the Below URL to drop the extended property:
http://msdn.microsoft.com/en-us/library/ms178595.aspx
61
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
