In case you are working in an organization that your managers are getting database documentation significantly, thumbs up! One of many methods to put in writing helpful documentation that’s actually efficient is utilizing SQL Server prolonged properties.

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

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 interior be a part of sys.objects o on e.major_id=o.object_id

All executed!