I am trying to generate a data dictionary for a table in my database.
Ideally I would like to export the column names, data type, restrictions and extended property descriptions.
How can this be achieved?
You can get at this via a combination of SELECT * FROM INFORMATION_SCHEMA.COLUMNS and using fn_listextendedproperty.