> 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

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

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

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}
