Database DBC
Equivalents for DBC objects and columns
DBC database
DBC
INFORMATION_SCHEMA
See DBC database
DBC tables
COLUMNS
COLUMNS
COLUMNSV
COLUMNS
DATABASES
DATABASES
DBQLOGTBL
TABLE(INFORMATION_SCHEMA.QUERY_HISTORY())
TABLES
TABLES
DBC columns
ALLRIGHTS
APPLICABLE_ROLES
COLUMNNAME
COLUMN_NAME
COLUMNUDTNAME
UDT_NAME
COMMENT_STRING
COMMENT
CREATETIMESTAMP
CREATED
COLUMNTYPE
DATA_TYPE
COLUMNLENGTH
CHARACTER_MAXIMUM_LENGTH
CONSTRAINTNAME
CONSTRAINT_NAME
CONSTRAINTTEXT
CONSTRAINT_TYPE
DATABASENAME
TABLE_SCHEMA
FINALWDNAME
SESSION_ID
FIRSTSTEPTIME
DATEADD(MILLISECOND, TOTAL_ELAPSED_TIME - EXECUTION_TIME, START_TIME)
LASTALTERTIMESTAMP
LAST_ALTERED
NULLABLE
IS_NULLABLE
STARTTIME
START_TIME
TABLEKIND
TABLE_TYPE
TABLE_LEVELCONSTRAINTS
TABLE_CONSTRAINTS
TABLENAME
TABLE_NAME
USER_NAME
GRANTEE
For more information about DBC tables and columns see the Teradata documentation.
Last updated