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 |