meta_FunctionParameters

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 parameters for the current functions in the systems in the repository. Corresponds to the relationship FunctionHasParameters.

Table 91: Columns and Data Types of the meta_FunctionParameters View
Column	Data Type	Values
SystemName	VARCHAR(256)
DatabaseName	VARCHAR(128)
FunctionName	VARCHAR(128)
ParameterName	VARCHAR(128)
ParameterDataType	CHAR(2)
ParameterDataTypeA	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 User Defined Type XML Year to Month	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 Unicode Fixed Character Year TD_ANYTYPE
CharType	SMALLINT
CharacterSet	VARCHAR(8)
RowTypeDatabaseName	VARCHAR(128)
RowTypeTableName	VARCHAR(128)
FunctionLoid	INTEGER
ParameterLoid	INTEGER