17.00 - AssociationV[X] - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

Category: Operations

Database: DBC

View Column Data Type Format Comment
DatabaseName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of the database or user space in which the imported object resides.
TableName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the imported object name.
EventNum INTEGER NOT NULL --,---,---,--9 Returns the client system event number of the restore operation.
Original_DatabaseName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of the original database in which the object resided.
Original_TableName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of the original object.
Original_TableKind CHAR(1) LATIN NOT CASESPECIFIC X(1) Original type of imported object.
Original_Version SMALLINT NOT NULL ---,--9 Returns the original version of the imported object.
Original_ProtectionType CHAR(1) LATIN UPPERCASE NOT NULL X(1) Returns the original protection type of the imported object, using the following codes: F = Fallback, N = None.
Original_JournalFlag CHAR(2) LATIN NOT CASESPECIFIC NOT NULL X(2) Original journaling for the imported object. Image status: first character BEFORE, second character AFTER.
Original_CreatorName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the original creator of the imported table.
Original_CommentString VARCHAR(255) UNICODE NOT CASESPECIFIC X(255) Returns the original comment on the imported table.