15.10 - ServerV[X] - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Operations

DBC

 

View Column

Data Type

Format

Source Table.Column

ServerID

BYTE(6)

NOT NULL

X(12)

TVM.TVMId

DatabaseName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

ServerName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

TVM.TVMName

CreatorName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

CreateTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

TVM.CreateTimeStamp

LastAlterName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

LastAlterTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

TVM.LastAlterTimeStamp

AuthorizationName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

TVM.AuthName

AuthorizationType

VARCHAR(15)

UNICODE

NOT CASESPECIFIC

X(15)

TVM.AuthorizationType

This Teradata QueryGrid connector Data Dictionary view provides details about the foreign servers defined in the Teradata Database system.

 

Value

Description

T

Invoker Trusted

S

Definer Trusted

''

Unknown

The following SELECT statement returns information about the foreign server objects created by user 'dba'.

select * from DBC.ServerV where CreatorName = 'dba';

Result:

 ServerID 000011960000
     DataBaseName TD_SERVER_DB
        ServerName SERVER_1
       CreatorName dba
   CreateTimeStamp 2014-12-02 19:51:46
     LastAlterName dba
LastAlterTimeStamp 2014-12-02 19:51:46
          ServerID 000012960000
      DataBaseName TD_SERVER_DB
        ServerName SERVER_2
       CreatorName dba
   CreateTimeStamp 2014-12-02 19:51:50
     LastAlterName dba
LastAlterTimeStamp 2014-12-02 19:51:50
AuthorizationName  user1
AuthorizationType  INVOKER TRUSTED

For more information, see Teradata QueryGrid documentation.