meta_FunctionTableColumns - Teradata Meta Data Services

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

meta_FunctionTableColumns

Returns the columns defined for the FunctionClass entries in the system. Corresponds to the relationship FunctionTableHasColumns.

 

Table 93: Columns and Data Types of the meta_FunctionTableColumns View 

Column

Data Type 

SystemName

VARCHAR(256)

DatabaseName

VARCHAR(128)

TableName

VARCHAR(128)

ColumnName

VARCHAR(128)

ColumnId

SHORT

ColumnLoid

INTEGER

ColumnType

CHAR(2)

ColumnTypeA

VARCHAR(29)

ColumnLength

INTEGER

CharType

SHORT

CharacterSet

VARCHAR(8)

DecimalTotalDigits

SHORT

DecimalFractDigits

SHORT

UppercaseFlag

VARCHAR(3)

Nullable

VARCHAR(3)

DefaultValue

VARCHAR(1024)

Compressible

VARCHAR(3)

CompressValue

VARCHAR(8192)

IDColType

VARCHAR(164)

IsSecurityConstraint

VARCHAR(3)

DerivedPeriod

VARCHAR(12)

ColumnTitle

VARCHAR(256)

CommentString

VARCHAR(255)