# SHOW Statements

- [About SHOW](/docs/server/reference/sql-statements/administrative-sql-statements/show/about-show.md): Overview of the SHOW statement syntax. Learn how to use patterns and WHERE clauses to filter output from various SHOW statements.
- [Extended SHOW](/docs/server/reference/sql-statements/administrative-sql-statements/show/extended-show.md): Understand the extensions to the SHOW statement. Learn how to use WHERE and LIKE clauses to perform complex filtering on metadata results.
- [SHOW ANALYZE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-analyze.md): Retrieve runtime statistics for a currently executing query. This statement provides insights into query plan execution without waiting for completion.
- [SHOW AUTHORS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-authors.md): Display a list of major contributors to the MariaDB and MySQL projects. View names, locations, and specific contributions of developers.
- [SHOW BINARY LOGS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-binary-logs.md): List the binary log files on the server. View the file names and sizes to monitor replication logs and manage disk usage.
- [SHOW BINLOG EVENTS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-binlog-events.md): Inspect the contents of a binary log file. This statement displays the events within a specific binlog, useful for debugging replication issues.
- [SHOW MASTER STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-binlog-status.md): View the current status of the primary server's binary log. This statement returns the current log file name and position for replication synchronization.
- [SHOW CHARACTER SET](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-character-set.md): List available character sets. View the default collation, maximum length, and description for each supported character set.
- [SHOW CLIENT\_STATISTICS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-client-statistics.md): View statistics on client connections. This statement displays metrics like bytes sent/received and busy time for connected clients.
- [SHOW COLLATION](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-collation.md): List available collations. View the character set associated with each collation and identifying properties like ID and default status.
- [SHOW COLUMNS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-columns.md): Complete guide to displaying table columns in MariaDB. Complete SHOW COLUMNS syntax with field types, keys, and filtering options for production use.
- [SHOW CONTRIBUTORS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-contributors.md): List financial contributors to the MariaDB Foundation. View the names and contributions of companies and individuals supporting the project.
- [SHOW CREATE DATABASE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-database.md): View the CREATE DATABASE statement. This statement returns the SQL syntax required to recreate a specific database with its current options.
- [SHOW CREATE EVENT](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-event.md): Get the SQL statement to recreate a scheduled event. This statement displays the complete syntax used to define a specific event.
- [SHOW CREATE FUNCTION](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-function.md): Retrieve the CREATE FUNCTION statement. This statement shows the exact SQL used to define a stored function, including its body and characteristics.
- [SHOW CREATE PACKAGE BODY](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-package-body.md): Display the CREATE statement for a package body. This Oracle-compatible statement shows the implementation code of a stored package.
- [SHOW CREATE PACKAGE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-package.md): View the CREATE PACKAGE statement. This statement returns the interface definition of a stored package in MariaDB.
- [SHOW CREATE PROCEDURE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-procedure.md): Get the CREATE PROCEDURE statement. This statement returns the SQL syntax used to define a specific stored procedure.
- [SHOW CREATE SEQUENCE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-sequence.md): View the SQL used to create a sequence. This statement displays the CREATE SEQUENCE statement with current parameter values.
- [SHOW CREATE SERVER](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-server.md): Display the CREATE SERVER statement. This statement shows the configuration details for a defined federated server connection.
- [SHOW CREATE TABLE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-table.md): Get the SQL statement to recreate a table. This statement shows the complete CREATE TABLE syntax, including column definitions and indexes.
- [SHOW CREATE TRIGGER](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-trigger.md): Retrieve the CREATE TRIGGER statement. This statement displays the SQL syntax defining a specific trigger and its timing events.
- [SHOW CREATE USER](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-user.md): View the CREATE USER statement. This statement returns the SQL required to recreate a user account with its authentication details.
- [SHOW CREATE VIEW](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-view.md): Display the CREATE VIEW statement. This statement shows the SQL query that defines a specific view structure.
- [SHOW DATABASES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-databases.md): Complete reference for listing databases in MariaDB. Complete SHOW DATABASES syntax with pattern matching and privilege considerations for production use.
- [SHOW ENGINE INNODB STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine-innodb-status.md): View extensive status information for the InnoDB engine. This statement displays details on deadlocks, buffer pool usage, and I/O activity.
- [SHOW ENGINE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engine.md): Display status information for a storage engine. This statement retrieves operational logs or status details for a specific engine.
- [SHOW ENGINES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engines.md): List available storage engines. View the support status (default, active, or disabled) and description for each engine.
- [SHOW ERRORS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-errors.md): Display errors from the last executed statement. View error codes, messages, and types for recent failures.
- [SHOW EVENTS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-events.md): List scheduled events. View metadata such as the event name, schedule, status, and timing for events in a database.
- [SHOW EXPLAIN](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-explain.md): Get the execution plan for a running query. This statement displays EXPLAIN output for a statement currently executing in another thread.
- [SHOW FUNCTION CODE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-function-code.md): Display the internal instruction representation of a stored function. This debug statement shows the low-level opcodes of the routine.
- [SHOW FUNCTION STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-function-status.md): List stored functions and their characteristics. View metadata like the database, name, type, and creator of stored functions.
- [SHOW GRANTS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-grants.md): Complete SHOW GRANTS reference for MariaDB. Complete syntax guide with filtering, pattern matching, and access control options with comprehensive examples.
- [SHOW INDEX\_STATISTICS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-index-statistics.md): View usage statistics for table indexes. This statement displays how often specific indexes are used, helping optimize query performance.
- [SHOW INDEX](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-index.md): Complete SHOW INDEX reference: SHOW {INDEX|INDEXES|KEYS} FROM tbl\_name syntax, output fields (Key\_name, Seq\_in\_index, Cardinality), and WHERE/LIKE filters.
- [SHOW INNODB STATUS (removed)](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-innodb-status-removed.md): Documentation for the deprecated SHOW INNODB STATUS statement. This statement was removed in favor of SHOW ENGINE INNODB STATUS.
- [SHOW LOCALES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-locales.md): List available error message locales. View the language IDs, names, and descriptions for supported localization settings.
- [SHOW OPEN TABLES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-open-tables.md): List currently open tables. View the database, table name, and lock status for tables in the table cache.
- [SHOW PACKAGE BODY STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-package-body-status.md): List stored package bodies. View metadata about the implementation part of Oracle-compatible packages.
- [SHOW PACKAGE STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-package-status.md): List stored packages. View metadata about the interface part of Oracle-compatible packages in the database.
- [SHOW PLUGINS SONAME](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-plugins-soname.md): List plugins and their library files. View information about installed plugins and their associated shared object names.
- [SHOW PLUGINS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-plugins.md): List installed server plugins. View the name, status, type, and library file for each active plugin.
- [SHOW PRIVILEGES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-privileges.md): List available system privileges. View the context and description for each privilege supported by the server.
- [SHOW PROCEDURE CODE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-procedure-code.md): Display the internal instruction representation of a stored procedure. This debug statement shows the low-level opcodes of the routine.
- [SHOW PROCEDURE STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-procedure-status.md): List stored procedures and their characteristics. View metadata like the database, name, type, and creator of stored procedures.
- [SHOW PROCESSLIST](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-processlist.md): Complete SHOW PROCESSLIST reference: FULL keyword for complete queries, PROCESS privilege, columns (Id, User, Host, db, Command, Time, State, Info).
- [SHOW PROFILE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-profile.md): Display profiling information for a query. View resource usage statistics like CPU and block IO for the most recent statement.
- [SHOW PROFILES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-profiles.md): List queries for which profiling data is available. View the query ID and duration for recent statements when profiling is enabled.
- [SHOW QUERY\_RESPONSE\_TIME](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-query_response_time.md): View the distribution of query execution times. This statement groups queries into time-based buckets to analyze performance.
- [SHOW RELAYLOG EVENTS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-relaylog-events.md): Inspect events in the relay log. This statement displays replication events from the relay log on a replica server.
- [SHOW REPLICA HOSTS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-replica-hosts.md): List registered replicas. This statement displays information about replica servers connected to the current primary.
- [SHOW REPLICA STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-replica-status.md): Complete SHOW REPLICA STATUS: FOR CHANNEL/connection\_name syntax, SHOW ALL REPLICAS option, thread states (Slave\_IO/SQL\_Running), and lag/log/GTID fields.
- [SHOW STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-status.md): View server status variables. This statement displays counters and metrics for server activity, performance, and health.
- [SHOW TABLE\_STATISTICS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-table-statistics.md): View usage statistics for tables. This statement displays metrics like rows read, changed, and updated for each table.
- [SHOW TABLE STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-table-status.md): Get metadata for tables. View details like engine type, row count, data length, and create time for tables in a database.
- [SHOW TABLES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-tables.md): Complete guide to listing tables in MariaDB. Complete SHOW TABLES syntax reference with LIKE patterns, WHERE conditions, and filtering options.
- [SHOW TRIGGERS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-triggers.md): List triggers defined on tables. View metadata such as the trigger event, timing, and the table it is associated with.
- [SHOW USER\_STATISTICS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-user-statistics.md): View statistics on user activity. This statement displays metrics like CPU time and rows read for each user account.
- [SHOW USER\_VARIABLES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-user_variables.md): List defined user variables. This statement displays the names and values of variables set in the current session.
- [SHOW VARIABLES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-variables.md): Complete SHOW VARIABLES reference: GLOBAL/SESSION scope syntax, LIKE 'pattern' matching, WHERE expression filters, and INFORMATION\_SCHEMA table queries.
- [SHOW WARNINGS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-warnings.md): Display warnings from the last executed statement. View warning codes, messages, and levels for recent operations.
- [SHOW WSREP\_MEMBERSHIP](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-wsrep_membership.md): View Galera Cluster membership. This statement displays the UUID, name, and address of nodes in the cluster.
- [SHOW WSREP\_STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-wsrep_status.md): View Galera Cluster status variables. This statement displays internal status metrics for the wsrep provider.