16.20 - TblSrvInfoV[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
ServerName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of the FOREIGN SERVER.
SrvDataBaseName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of the database or user in which the subject foreign server resides.
TblOpName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of the table operator.
TbpOpDataBaseName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of the database database or user in which the subject table operator resides.
NameInfo VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the value portion specified in the custom-clause.
ValueInfo VARCHAR(31000) UNICODE NOT CASESPECIFIC X(31000) Returns the value portion specified in the custom-clause.
ValueType CHAR(1) LATIN NOT CASESPECIFIC X(1) Return the identifier to identify whether the value specified in custom-clause is either SELECT/Value/System.
TableOperatorType VARCHAR(7) UNICODE NOT CASESPECIFIC X(7) Returns the single character field representing table operator type.