Home > Posts > SQL Server Data Dictionary

This script generates a full data dictionary for all tables in a SQL Server database.

Download data_dictionary.sql (Right Click->Save Target As...).

It includes schemas, foreign keys, primary keys, nulls, identities, data types, lengths, default values and descriptions.

If you're looking for something more polished, I've also wrapped this functionality up plus some into SQL Data Dictionary.

Please send any questions or comments to Bruce Dunwiddie.