16.20 - ZonesV[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: Security

Database: DBC

View Column Data Type Format Comment
ZoneName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of a zone.
RootName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the zone root name.
RootType CHAR(1) LATIN UPPERCASE X(1) Returns 'U' if the root of a zone is user and 'D' if the root of a zone is database.
ZoneDBAName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the zone's primary DBA name.
CreatorName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the zone creator name.
CreateTimeStamp TIMESTAMP(0) NOT NULL YYYY-MM-DDBHH:MI:SS Returns the creation timestamp of a zone.