Data Dictionary and the System Catalog
Data dictionary contains metadata to provide detailed accounting of all tables within the database.
System catalog is a very detailed system data dictionary that describes all objects within the database.
- System catalog is a system-created database whose tables store the database characteristics and contents.
- System catalog tables can be queried just like any other tables.
- System catalog automatically produces database documentation.