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