EXA_SYS_SCRIPTS

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