meta_StoredProcViewColumns - 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_StoredProcViewColumns

Returns the view columns referenced by the current stored procedures in systems being tracked by MDS. Corresponds to the relationship SPReferencesViewColumns.

 

Table 135: Columns and Data Types of the meta_StoredProcViewColumns View  

Column

Data Type

SystemName

VARCHAR(256)

DatabaseName

VARCHAR(128)

StoredProcedureName

VARCHAR(128)

ViewDatabaseName

VARCHAR(128)

ViewName

VARCHAR(128)

ColumnName

VARCHAR(128)

StoredProcedureLoid

INTEGER

ColumnLoid

INTEGER