EXA_USER_SCRIPTS

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