question prolonged properties

If you’re working in an organization that your managers are getting database documentation critically, thumbs up! One of many methods to write down helpful documentation that’s actually efficient is utilizing SQL Server prolonged properties.

We are able to add prolonged properties to virtually all SQL Server objects by proper clicking on the object-> choose properties-> choose “Prolonged Properties” and add new properties to the article.


So, after including the brand new properties we would want to question these properties sooner or later.

Executing the next T-SQL script retrieves what we want:

choose O.identify ObjectName, e.identify PropertyName, worth

from sys.extended_properties e inside be part of sys.objects o on e.major_id=o.object_id



All completed!

Supply hyperlink

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button