How would I create a data dictionary using the MS_Description column in the extended properties and the information_schema columns? I would like to include table name, column name, data type, null/not null, and ms_description.
Has anyone done this or created a data dictionary in SQL Server any other way before?