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. |