meta_ViewColumnConstants

Teradata Meta Data Services User Guide

Product

Teradata Meta Data Services

Release Number

15.00

Language

English (United States)

Last Update

2018-09-27

Product Category

Teradata Tools and Utilities

Returns the Constants referenced by the current view columns in systems being tracked by MDS. Corresponds to the relationship ViewColumnReferencesConstants.

Table 151: Columns, Data Types, and Values of the meta_ViewColumnConstants View
Column	Data Type	Values
SystemName	VARCHAR(256)
DatabaseName	VARCHAR(128)
ViewName	VARCHAR(128)
ViewColumnName	VARCHAR(128)
ConstantType	VARCHAR(128)	ACCOUNT ACTIVITY_COUNT ALL ANSIDATE ASCII AUTOTEMP AVERAGE BIGINT BINARY CHAR_SET_GRAPHIC CHARSET_COLL CURRENT_ROLE CURRENT_USER CURRDATE CURRTIME CURRTIMESTAMP DATABASE DATE DECIMAL DEFAULT DENSE DQUOTESTR EBCDIC FLOAT HEXSTR HIGH HOST INTEGER INTEGERDATE	JIS_COLL KANJI KANJISJIS LATIN1 LOCAL LOW MANUAL MEDIUM MULTINATIONAL NAME NEVER OFF NULL PARMNAME PREPARE_COUNT PROFILE ROLE SESSION SOURCE TIME ZONE SQLCODE SQLSTATE SQUOTESTR STAR TEMPORAL_DATE TEMPORAL_TIMESTAMP TIME UNICODE UNKNOWN USER ZONE
ConstantValue	VARCHAR(1024)
ColumnLoid	INTEGER
ConstantLoid	INTEGER