Thursday, July 15, 2010

Extended Property Awesomeness

There has been some discussion today on twitter about extended properties. A while back I wrote an article for MSSQLTips about using extended properties to create a Data Dictionary. I really should have included an image of the sample output since it takes several steps to get to the final document. So here is a preview of what the script generates against the AdventureWorks database. I also should have not included “and exprop.class = 1” in the WHERE clause. If you want to get all the information even if you don’t have extended properties, make sure to remove that statement. I have outlined the extended properties in red. You can see that it picks up extended properties for the table as well as the columns.