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      |BULK_IMPORT_HFILE                         |com.splicemachine. ...
SYSCS_UTIL      |COLLECT_NONMERGED_TABLE_SAMPLE_STATISTICS |com.splicemachine. ...
SYSCS_UTIL      |COLLECT_NONMERGED_TABLE_STATISTICS        |com.splicemachine. ...
SYSCS_UTIL      |COLLECT_SCHEMA_STATISTICS                 |com.splicemachine. ...
SYSCS_UTIL      |COLLECT_TABLE_SAMPLE_STATISTICS           |com.splicemachine. ...
SYSCS_UTIL      |COLLECT_TABLE_STATISTICS                  |com.splicemachine. ...
SYSCS_UTIL      |COMPACT_REGION                            |com.splicemachine. ...
SYSCS_UTIL      |COMPUTE_SPLIT_KEY                         |com.splicemachine. ...
SYSCS_UTIL      |DELETE_REGION                             |com.splicemachine. ...
SYSCS_UTIL      |DELETE_SNAPSHOT                           |com.splicemachine. ...
SYSCS_UTIL      |DISABLE_ALL_COLUMN_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_ALL_COLUMN_STATISTICS              |com.splicemachine. ...
SYSCS_UTIL      |ENABLE_COLUMN_STATISTICS                  |com.splicemachine. ...
SYSCS_UTIL      |GET_ACTIVATION                            |com.splicemachine. ...
SYSCS_UTIL      |GET_ENCODED_REGION_NAME                   |com.splicemachine. ...
SYSCS_UTIL      |GET_REGIONS                               |com.splicemachine. ...
SYSCS_UTIL      |GET_START_KEY                             |com.splicemachine. ...
SYSCS_UTIL      |IMPORT_DATA                               |com.splicemachine. ...
SYSCS_UTIL      |IMPORT_DATA_UNSAFE                        |com.splicemachine. ...
SYSCS_UTIL      |INVALIDATE_DICTIONARY_CACHE               |com.splicemachine. ...
SYSCS_UTIL      |INVALIDATE_GLOBAL_DICTIONARY_CACHE        |com.splicemachine. ...
SYSCS_UTIL      |MAJOR_COMPACT_REGION                      |com.splicemachine. ...
SYSCS_UTIL      |MERGE_DATA_FROM_FILE                      |com.splicemachine. ...
SYSCS_UTIL      |MERGE_REGIONS                             |com.splicemachine. ...
SYSCS_UTIL      |RESTORE_SNAPSHOT                          |com.splicemachine. ...
SYSCS_UTIL      |SAMPLE_DATA                               |com.splicemachine. ...
SYSCS_UTIL      |SET_PURGE_DELETED_ROWS                    |com.splicemachine. ...
SYSCS_UTIL      |SNAPSHOT_SCHEMA                           |com.splicemachine. ...
SYSCS_UTIL      |SNAPSHOT_TABLE                            |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_BACKUP_DATABASE                     |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_BACKUP_DATABASE_ASYNC               |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_CANCEL_BACKUP                       |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_CANCEL_DAILY_BACKUP                 |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_CANCEL_SPLICE_TOKEN                 |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_DICTIONARY_DELETE                   |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_CACHE_INFO                      |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_GET_CURRENT_TRANSACTION             |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_GET_EXEC_SERVICE_INFO               |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_RUNNING_OPERATIONS              |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_GET_RUNNING_OPERATIONS_LOCAL        |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_GET_SCHEMA_INFO                     |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_GET_SESSION_INFO                    |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_GET_SPLICE_TOKEN                    |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_TOTAL_CACHE_INFO                |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_GET_VERSION_INFO                    |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_GET_WRITE_INTAKE_INFO               |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_HBASE_OPERATION                     |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_HDFS_OPERATION                      |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_INVALIDATE_STORED_STATEMENTS        |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_KILL_OPERATION                      |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_KILL_OPERATION_LOCAL                |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_ASYNC              |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_RESTORE_DATABASE_OWNER              |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_SCHEDULE_DAILY_BACKUP               |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_SET_DATABASE_PROPERTY               |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_SPLIT_TABLE_OR_INDEX                |com.splicemachine. ...
SYSCS_UTIL      |SYSCS_SPLIT_TABLE_OR_INDEX_AT_POINTS      |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. ...
107 rows selected