SHOW Statements
View server metadata and status. This section lists SHOW statements for inspecting databases, tables, variables, and performance metrics.
About SHOWExtended SHOWSHOW ANALYZESHOW AUTHORSSHOW BINARY LOGSSHOW BINLOG EVENTSSHOW MASTER STATUSSHOW CHARACTER SETSHOW CLIENT_STATISTICSSHOW COLLATIONSHOW COLUMNSSHOW CONTRIBUTORSSHOW CREATE DATABASESHOW CREATE EVENTSHOW CREATE FUNCTIONSHOW CREATE PACKAGE BODYSHOW CREATE PACKAGESHOW CREATE PROCEDURESHOW CREATE SEQUENCESHOW CREATE SERVERSHOW CREATE TABLESHOW CREATE TRIGGERSHOW CREATE USERSHOW CREATE VIEWSHOW DATABASESSHOW ENGINE INNODB STATUSSHOW ENGINESHOW ENGINESSHOW ERRORSSHOW EVENTSSHOW EXPLAINSHOW FUNCTION CODESHOW FUNCTION STATUSSHOW GRANTSSHOW INDEX_STATISTICSSHOW INDEXSHOW INNODB STATUS (removed)SHOW LOCALESSHOW OPEN TABLESSHOW PACKAGE BODY STATUSSHOW PACKAGE STATUSSHOW PLUGINS SONAMESHOW PLUGINSSHOW PRIVILEGESSHOW PROCEDURE CODESHOW PROCEDURE STATUSSHOW PROCESSLISTSHOW PROFILESHOW PROFILESSHOW QUERY_RESPONSE_TIMESHOW RELAYLOG EVENTSSHOW REPLICA HOSTSSHOW REPLICA STATUSSHOW STATUSSHOW TABLE_STATISTICSSHOW TABLE STATUSSHOW TABLESSHOW TRIGGERSSHOW USER_STATISTICSSHOW USER_VARIABLESSHOW VARIABLESSHOW WARNINGSSHOW WSREP_MEMBERSHIPSHOW WSREP_STATUS
Last updated
Was this helpful?