This system table describes all scripts of the database. Only users with the SELECT ANY DICTIONARY system privilege 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 (SCRIPTING, 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 |
