MariaDB/SQL/SHOW

SQL command: SHOW

Reference

• About SHOW: brief overview
• SHOW Statements: list of SHOW subcommands

Subcommands

• 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
  • EVENT
  • FUNCTION
  • PACKAGE BODY
  • PACKAGE
  • PROCEDURE
  • SEQUENCE
  • SERVER
  • TABLE
  • TRIGGER
  • USER
  • 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