Monday, March 26, 2012

Script to remove all extended properties?

Hi
Does anyone know of a way / script to remove all extended properties from
objects within a certain database?
Tia
James
tglThe documented way is to use sp_dropextendedproperty for each property
of each object (which can be found using fn_listextendedproperty).
An undocumented way would be:
DELETE sysproperties
(this may not work in later versions of SQL Server)
Razvan

No comments:

Post a Comment