The Procedures schema returns information about SQL STORED PROCEDURE and or EXTERNAL STORED PROCEDURE objects by accessing the Advanced SQL Engine Data Dictionary views. It will access DBC.TABLES[V] or DBC.TABLES[V]X Data Dictionary view based on UseXViews Connection setting.
Column Name | Data Type | Description |
---|---|---|
Id | String | Returns a unique Id for the PROCEDURE. |
CatalogName | String | This field is always set to NULL. |
SchemaName | String | Returns the name of the DATABASE in which the PROCEDURE object resides. |
Name | String | Returns the name of the PROCEDURE. |