This system table describes all of the scripts in the database owned by the current user. All users have access to the table.
| Column Name | Description |
|---|---|
| SCRIPT_SCHEMA | Name of the schema of the script |
| SCRIPT_NAME | Name of the script |
| SCRIPT_OWNER | Owner of the script |
| SCRIPT_OBJECT_ID | ID of the script object |
| SCRIPT_TYPE | Type of the script (PROCEDURE, ADAPTER or UDF) |
| SCRIPT_LANGUAGE | Script language |
| SCRIPT_INPUT_TYPE | Script input type (NULL, SCALAR or SET) |
| SCRIPT_RESULT_TYPE | Return type of the script (NULL , ROWCOUNT, TABLE, RETURNS or EMITS) |
| SCRIPT_TEXT | Complete creation text for a script |
| SCRIPT_COMMENT | Comment on the script |