Data Dictionary views fall into the following categories:
| Category | Information Stored |
|---|---|
| Operations | Internal database operations |
| Database | Database instance and owner |
| Schema | Database schema (tables, columns, and so on) |
| Integrity | Data integrity (constraints and so on) |
| Security | Data security (roles, grants, access, and so on) |
| Query | Database Query Log |
| Accounting | Database usage (accounts, space, and so on) |
| Optimizer Statistics | Statistics collected on indexed, non-indexed columns (including row and column PARTITION statistics) and expressions on permanent tables, base and materialized global temporary tables (for the current session) and join indexes. |
| TDMaps | Stores metadata that is used by the system when moving tables to new maps. See TDMaps Views. |
| Cloud | Stores operational groups information for the cloud database. |
The results shown in the examples in the following sections are for illustration purposes only. You can use utilities and tools, such as BTEQ or other third-party products, to enter queries and format the results differently.