Show Procedures

The show procedures command displays all of the procedures that have been created with the create procedure statement in the database or specified schema.

Syntax

SHOW PROCEDURES [ IN schemaName ]

schemaName

If you supply a schema name, only the procedures in that schema are displayed; otherwise, all procedures in the database are displayed.

Results

The show procedures command results contains the following columns:

Column Name Description
PROCEDURE_SCHEMA The name of the procedure's schema
PROCEDURE_NAME The name of the procedure
REMARKS Any remarks that have been stored for the procedure

Examples

splice> show procedures in syscs_util;
PROCEDURE_SCHEM |PROCEDURE_NAME                           |REMARKS
---------------------------------------------------------------------------------SYSCS_UTIL      |COLLECT_SCHEMA_STATISTICS                |com.splicemachine. ...
SYSCS_UTIL      |COLLECT_TABLE_STATISTICS                 |com.splicemachine. ...
SYSCS_UTIL      |DISABLE_COLUMN_STATISTICS                |com.splicemachine. ...
SYSCS_UTIL      |DROP_SCHEMA_STATISTICS                   |com.splicemachine. ...
SYSCS_UTIL      |DROP_TABLE_STATISTICS                    |com.splicemachine. ...
SYSCS_UTIL      |ENABLE_COLUMN_STATISTICS                 |com.splicemachine. ...
SYSCS_UTIL      |GET_ACTIVATION                           |com.splicemachine. ...
SYSCS_UTIL      |IMPORT_DATA                              |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_BACKUP_DATABASE                    |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_CANCEL_BACKUP                      |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_CANCEL_DAILY_BACKUP                |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_COMMIT_CHILD_TRANSACTION           |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_CREATE_USER                        |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_DELETE_BACKUP                      |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_DELETE_OLD_BACKUPS                 |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_DROP_USER                          |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_ELEVATE_TRANSACTION                |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_EMPTY_GLOBAL_STATEMENT_CACHE       |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_EMPTY_STATEMENT_CACHE              |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_ENABLE_ENTERPRISE                  |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_FLUSH_TABLE                        |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_GET_ACTIVE_SERVERS                 |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_GET_ACTIVE_TRANSACTION_IDS         |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_GET_ALL_PROPERTIES                 |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_GET_AUTO_INCREMENT_ROW_LOCATIONS   |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_GET_CURRENT_TRANSACTION            |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_GET_GLOBAL_DATABASE_PROPERTY       |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_GET_LOGGERS                        |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_GET_LOGGER_LEVEL                   |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_GET_REGION_SERVER_CONFIG_INFO      |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_GET_REGION_SERVER_STATS_INFO       |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_GET_REQUESTS                       |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_GET_SCHEMA_INFO                    |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_GET_STORED_STATEMENT_PLAN_INFO     |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_GET_TIMESTAMP_GENERATOR_INFO       |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_GET_TIMESTAMP_REQUEST_INFO         |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_GET_VERSION_INFO                   |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_GET_WRITE_INTAKE_INFO              |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_INVALIDATE_STORED_STATEMENTS       |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_KILL_STALE_TRANSACTIONS            |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_KILL_TRANSACTION                   |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_MODIFY_PASSWORD                    |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_PERFORM_MAJOR_COMPACTION_ON_SCHEMA |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_PERFORM_MAJOR_COMPACTION_ON_TABLE  |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_RECOMPILE_INVALID_STORED_STATEMENTS|com.splicemachine. ...
SYSCS_UTIL      |SYSCS_REFRESH_EXTERNAL_TABLE             |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_RELOAD_SECURITY_POLICY             |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_RESET_PASSWORD                     |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_RESTORE_DATABASE                   |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_RESTORE_DATABASE_OWNER             |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_SCHEDULE_DAILY_BACKUP              |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_SET_GLOBAL_DATABASE_PROPERTY       |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_SET_LOGGER_LEVEL                   |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_SET_USER_ACCESS                    |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_SPLIT_REGION_AT_POINTS             |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_SPLIT_TABLE                        |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_SPLIT_TABLE_AT_POINTS              |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_SPLIT_TABLE_EVENLY                 |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_START_CHILD_TRANSACTION            |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_UPDATE_ALL_SYSTEM_PROCEDURES       |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_UPDATE_METADATA_STORED_STATEMENTS  |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_UPDATE_SCHEMA_OWNER                |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_UPDATE_SYSTEM_PROCEDURE            |com.splicemachine. ...
SYSCS_UTIL      |UPSERT_DATA_FROM_FILE                    |com.splicemachine. ...
SYSCS_UTIL      |VACUUM                                   |com.splicemachine. ...
66 rows selected