15.10 - Chapter 3 Views Reference - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
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:

 

Type

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 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.