meta_StoredProcedures - 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_StoredProcedures

Returns the current stored procedures in the databases of the repository systems. Corresponds to the relationship DatabaseHasStoredProcedures.

 

Table 128: Columns and Data Types of the meta_StoredProcedures View  

Column

Data Type

SystemName

VARCHAR(256)

DatabaseName

VARCHAR(128)

StoredProcedureName

VARCHAR(128)

SPLastAlterTS

TIMESTAMP

IsSynchronized

VARCHAR(6)

SPComment

VARCHAR(255)

SPText

VARCHAR(12500)

CreatorName

VARCHAR(128)

SPLoid

INTEGER