17.00 - ServerV[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
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.