SHOW Statements

View server metadata and status. This section lists SHOW statements for inspecting databases, tables, variables, and performance metrics.

• About SHOW

• Extended SHOW

• SHOW ANALYZE

• SHOW AUTHORS

• SHOW BINARY LOGS

• SHOW BINLOG EVENTS

• SHOW MASTER STATUS

• SHOW CHARACTER SET

• SHOW CLIENT_STATISTICS

• SHOW COLLATION

• SHOW COLUMNS

• SHOW CONTRIBUTORS

• SHOW CREATE DATABASE

• SHOW CREATE EVENT

• SHOW CREATE FUNCTION

• SHOW CREATE PACKAGE BODY

• SHOW CREATE PACKAGE

• SHOW CREATE PROCEDURE

• SHOW CREATE SEQUENCE

• SHOW CREATE SERVER

• SHOW CREATE TABLE

• SHOW CREATE TRIGGER

• SHOW CREATE USER

• SHOW CREATE VIEW

• SHOW DATABASES

• SHOW ENGINE INNODB STATUS

• SHOW ENGINE

• SHOW ENGINES

• SHOW ERRORS

• SHOW EVENTS

• SHOW EXPLAIN

• SHOW FUNCTION CODE

• SHOW FUNCTION STATUS

• SHOW GRANTS

• SHOW INDEX_STATISTICS

• SHOW INDEX

• SHOW INNODB STATUS (removed)

• SHOW LOCALES

• SHOW OPEN TABLES

• SHOW PACKAGE BODY STATUS

• SHOW PACKAGE STATUS

• SHOW PLUGINS SONAME

• SHOW PLUGINS

• SHOW PRIVILEGES

• SHOW PROCEDURE CODE

• SHOW PROCEDURE STATUS

• SHOW PROCESSLIST

• SHOW PROFILE

• SHOW PROFILES

• SHOW QUERY_RESPONSE_TIME

• SHOW RELAYLOG EVENTS

• SHOW REPLICA HOSTS

• SHOW REPLICA STATUS

• SHOW STATUS

• SHOW TABLE_STATISTICS

• SHOW TABLE STATUS

• SHOW TABLES

• SHOW TRIGGERS

• SHOW USER_STATISTICS

• SHOW USER_VARIABLES

• SHOW VARIABLES

• SHOW WARNINGS

• SHOW WSREP_MEMBERSHIP

• SHOW WSREP_STATUS