15.10 - Chapter 3 Views Reference - Teradata Database

Teradata Database Data Dictionary

Teradata Database
Release Number
Content Type
User Guide
Publication ID
English (United States)

You can use Teradata Studio or Teradata Studio Express to view the Data Dictionary. For information about these tools or to download them, go to: http://developer.teradata.com

The following topics describe all the Data Dictionary views in alphabetical order. The columns of each view are listed in the order they appear in SQL Assistant’s Show Definition.

DBC.UserDB and DBC.OwnerDB system views are not covered in this manual because they are not usually referenced directly by users. These views are used only to join other system tables and views (especially the X version of views).

Data Dictionary views fall into the following categories:



Information Stored


Internal database operations


Database instance and owner


Database schema (tables, columns, and so on)


Data integrity (constraints and so on)


Data security (roles, grants, access, and so on)


Database Query Log


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 and hash indexes.

Data Dictionary views consist of one or more columns. The information for each view below shows the source table for that column. If the Source Table.Column value is None, the column is a derived value. Many of the Data Dictionary view columns have referenced table columns. That is, the value in the view column selected corresponds to a value in the column referenced in the table. It would be meaningful to join the view and the referenced table based on the selected column and the referenced column. Referenced columns are indicated by a note in Source Table.Column.

Note: The results shown in the examples 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.

Some column formats are explicit, while others are not. "Explicit" means that the format string is specified by the Table Initializer program. When "explicit" is not specified, the format is taken from the default format for the data type for the column.