16.20 - ServerV[X] - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

Category: Operations

Database: DBC

View Column Data Type Format Comment
ServerID BYTE(6) NOT NULL X(12) Returns the identifier of the FOREIGN SERVER (TVMId column in DBC.TVM).
DataBaseName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of the database or user in which the subject foreign server resides.
ServerName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of the FOREIGN SERVER.
CreatorName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the Teradata User who issued the CREATE FOREIGN SERVER statement
CreateTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the time when CREATE FOREIGN SERVER statement was issued.
LastAlterName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of the user who last updated the dictionary row.
LastAlterTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the time the dictionary row was last updated.
AuthorizationName VARCHAR(128) UNICODE UPPERCASE X(128) Returns the authorization name specified in the external security clause of the foreign server.
AuthorizationType VARCHAR(15) UNICODE NOT CASESPECIFIC X(15) Returns the type of authorization INVOKER TRUSTED or DEFINER TRUSTED.
ExecMapName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the execution map name of a foreign server. NULL indicates the foreign server does not have a execute map.
ExecMapColocName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the ColocationName of the execution map of a foreign server.