> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show.md).

# SHOW Statements

* [About SHOW](/docs/server/reference/sql-statements/administrative-sql-statements/show/about-show.md)
* [Extended SHOW](/docs/server/reference/sql-statements/administrative-sql-statements/show/extended-show.md)
* [SHOW ANALYZE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-analyze.md)
* [SHOW AUTHORS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-authors.md)
* [SHOW BINARY LOGS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-binary-logs.md)
* [SHOW BINLOG EVENTS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-binlog-events.md)
* [SHOW MASTER STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-binlog-status.md)
* [SHOW CHARACTER SET](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-character-set.md)
* [SHOW CLIENT\_STATISTICS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-client-statistics.md)
* [SHOW COLLATION](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-collation.md)
* [SHOW COLUMNS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-columns.md)
* [SHOW CONTRIBUTORS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-contributors.md)
* [SHOW CREATE DATABASE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-database.md)
* [SHOW CREATE EVENT](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-event.md)
* [SHOW CREATE FUNCTION](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-function.md)
* [SHOW CREATE PACKAGE BODY](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-package-body.md)
* [SHOW CREATE PACKAGE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-package.md)
* [SHOW CREATE PROCEDURE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-procedure.md)
* [SHOW CREATE SEQUENCE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-sequence.md)
* [SHOW CREATE SERVER](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-server.md)
* [SHOW CREATE TABLE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-table.md)
* [SHOW CREATE TRIGGER](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-trigger.md)
* [SHOW CREATE USER](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-user.md)
* [SHOW CREATE VIEW](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-view.md)
* [SHOW DATABASES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-databases.md)
* [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md)
* [SHOW ENGINE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine.md)
* [SHOW ENGINES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engines.md)
* [SHOW ERRORS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-errors.md)
* [SHOW EVENTS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-events.md)
* [SHOW EXPLAIN](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-explain.md)
* [SHOW FUNCTION CODE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-function-code.md)
* [SHOW FUNCTION STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-function-status.md)
* [SHOW GRANTS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-grants.md)
* [SHOW INDEX\_STATISTICS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-index-statistics.md)
* [SHOW INDEX](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-index.md)
* [SHOW INNODB STATUS (removed)](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-innodb-status-removed.md)
* [SHOW LOCALES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-locales.md)
* [SHOW OPEN TABLES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-open-tables.md)
* [SHOW PACKAGE BODY STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-package-body-status.md)
* [SHOW PACKAGE STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-package-status.md)
* [SHOW PLUGINS SONAME](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-plugins-soname.md)
* [SHOW PLUGINS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-plugins.md)
* [SHOW PRIVILEGES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-privileges.md)
* [SHOW PROCEDURE CODE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-procedure-code.md)
* [SHOW PROCEDURE STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-procedure-status.md)
* [SHOW PROCESSLIST](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-processlist.md)
* [SHOW PROFILE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-profile.md)
* [SHOW PROFILES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-profiles.md)
* [SHOW QUERY\_RESPONSE\_TIME](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-query_response_time.md)
* [SHOW RELAYLOG EVENTS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-relaylog-events.md)
* [SHOW REPLICA HOSTS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-replica-hosts.md)
* [SHOW REPLICA STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-replica-status.md)
* [SHOW STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-status.md)
* [SHOW TABLE\_STATISTICS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-table-statistics.md)
* [SHOW TABLE STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-table-status.md)
* [SHOW TABLES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-tables.md)
* [SHOW TRIGGERS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-triggers.md)
* [SHOW USER\_STATISTICS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-user-statistics.md)
* [SHOW USER\_VARIABLES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-user_variables.md)
* [SHOW VARIABLES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-variables.md)
* [SHOW WARNINGS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-warnings.md)
* [SHOW WSREP\_MEMBERSHIP](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-wsrep_membership.md)
* [SHOW WSREP\_STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-wsrep_status.md)