Alex Rivera | Logout

Drop all extended properties on SQL Server

Asked 2012-09-11T11:14:56.640
12

How to drop all extended properties on SQL Server in a scriptable way?

sql-server sql-server-2008 sql-server-2005 sql-server-2008-r2
Edit
Report

1 Answer

5

use this script 

EXEC sys.sp_dropextendedproperty 
     @name  =N'MS_Description', 
     @level0type = N'SCHEMA', 
     @level0name = N'dbo',
     @level1type = N'TABLE',
     @level1name = N'ActivityEventRecipient';
GO

Source:drop extended property

answered 2012-09-11T12:02:13.390

Your Answer