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.

clip_image002

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

 

clip_image003

All completed!



Supply hyperlink

Leave a Reply

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