meta_ViewColumns

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 columns for the current views in the systems in the repository. Corresponds to the relationship ViewHasColumns.

Table 153: Columns, Data Types, and Values of the meta_ViewColumns View
Column	Data Type	Values
SystemName	VARCHAR(256)
DatabaseName	VARCHAR(128)
ViewName	VARCHAR(128)
ColumnName	VARCHAR(128)
ColumnID	SMALLINT
ColumnLoid	INTEGER
ColumnType	CHAR(2)
ColumnTypeA	VARCHAR(29)	1-dimensional Array ANSI Time BLOB VARBYTE CLOB Decimal Day Day to Minute Date Tag Hour Hour To Second Byte Integer BIGINT Minute Minute To Second PERIOD(TIME) PERIOD(TIMESTAMP) Second TD_VALIST Timestamp User Defined Type Unicode VARCHAR Year	n-dimensional Array Binary Fixed Binary String Character Fixed VARCHAR Date Day To Hour Day to Second Real/Float Hour To Minute Integer Short Integer JSON Month NUMBER PERIOD(DATE) PERIOD(TIME)w/TimeZone PERIOD(TIMESTAMP)w/TimeZone Timestamp w/ TimeZone ANSI Timestamp w/ TimeZone Unicode Fixed Character XML Year To Month
ColumnLength	INTEGER
CharType	SMALLINT
CharacterSet	VARCHAR(8)	Graphic Latin Unicode	Kanji1 ShiftJIS Other
DecimalTotalDigits	SMALLINT
DecimalFractDigits	SMALLINT
Nullable	VARCHAR(3)
ColumnTitle	VARCHAR(256)
CommentString	VARCHAR(255)