meta_MacroStoredProcedures - Teradata Meta Data Services

meta_MacroStoredProcedures

Returns the Stored Procedures referenced by the current macros in systems being tracked by MDS. Corresponds to the relationship MacroReferencesSPs.

Table 113: Columns and Data Types of the meta_MacroStoredProcedures View  

Column	Data Type
SystemName	VARCHAR(256)
DatabaseName	VARCHAR(128)
MacroName	VARCHAR(128)
SPDatabaseName	VARCHAR(128)
SPName	VARCHAR(128)
MacroLoid	INTEGER
SPLoid	INTEGER