Database DBC

Equivalents for DBC objects and columns

The DBC database contains critical system tables that define the user databases in the Analytics Database / Teradata Database. In the next segments, you can see the supported objects and columns of DBC database, the ones missing are not supported yet.

DBC database

Teradata	Snowflake	Notes
DBC	INFORMATION_SCHEMA

See DBC database

DBC tables

Teradata	Snowflake	Notes
COLUMNS	COLUMNS
COLUMNSV	COLUMNS
DATABASES	DATABASES
DBQLOGTBL	TABLE(INFORMATION_SCHEMA.QUERY_HISTORY())
TABLES	TABLES

DBC columns

Teradata	Snowflake	Notes
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.