meta_Columns

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 tables, views, macros, and stored procedures defined in systems being tracked by MDS. The TVType fields returns 'T' for a table, 'V' for a view, 'M' for a macro, and 'P' for a stored procedure.

Table 81: Columns, Data Types, and Values of the meta_Columns View
Column	Data Type	Values
SystemName	VARCHAR(256)
DatabaseName	VARCHAR(128)
TVType	VARCHAR(2)	T = Table V = View M = Macro P = Stored Procedure
TableName	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 Month PERIOD(DATE) PERIOD(TIME)w/TimeZone PERIOD(TIMESTAMP)w/TimeZone Timestamp w/ TimeZone ANSI Timestamp w/ TimeZone Unicode Fixed Character 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 Minute To Second NUMBER PERIOD(TIME) PERIOD(TIMESTAMP) Second TD_VALIST Timestamp User Defined Type XML Year To Month
ColumnLength	INTEGER
CharType	SMALLINT
CharacterSet	VARCHAR(8)	Graphic Latin Unicode	Kanji1 ShiftJIS Other
DecimalTotalDigits	SMALLINT
DecimalFractionalDigits	SMALLINT
UppercaseFlag	VARCHAR(3)
Nullable	VARCHAR(3)
DefaultValue	VARCHAR(1024)
Compressible	VARCHAR(3)
CompressValue	VARCHAR(8192)
IDColType	VARCHAR(164)
SPParameterType	VARCHAR(1)
ColumnTitle	VARCHAR(256)
CommentString	VARCHAR(255)
ColumnUDTName	VARCHAR(128)