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. |