17.10 - JoinIndicesV - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)

Category: Schema

Database: DBC

View Column Data Type Format Comment
DataBaseName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of a database.
TableName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of a table, join index, or hash index.
JoinIdxDataBaseName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the join index database name.
JoinIdxName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the join index name.
IndexType CHAR(1) LATIN UPPERCASE NOT NULL X(1) Returns the type of an index as Index type.