Every developer, database or not, has had those moments when someone wants the data dictionary. Instead of the painful task of hand typing it out here are a couple data dictionary scripts to get you started.

SQL Server Data Dictionary Script

Need more detail? Microsoft online documentation can help.

Oracle Data Dictionary Script

If you want to take Oracle a step further, check out Oracle’s online documentation.