In case you are working in an organization that your managers are getting database documentation significantly, thumbs up! One of many methods to write down helpful documentation that’s actually efficient is utilizing SQL Server prolonged properties.
We will 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 thing.
So, after including the brand new properties we’d 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 carried out!