This system table describes all system scripts of the database. 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 |
