> 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/table-statements.md).

# Table Statements

{% columns %}
{% column %}
{% content-ref url="/pages/UwBG1CGSem2VHN4SDO6s" %}
[ALTER](/docs/server/reference/sql-statements/data-definition/alter.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Access the reference for `ALTER` statements. This section lists commands to modify existing database objects, including tables, databases, users, and servers.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/zQ663vOS8tEnQkPqI2MG" %}
[ALTER TABLE](/docs/server/reference/sql-statements/data-definition/alter/alter-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete `ALTER TABLE` guide for MariaDB. Complete syntax for modifying columns, indexes, constraints, and table properties with comprehensive examples.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/WJ0lcpIMql3eKNwOHIwT" %}
[ANALYZE TABLE](/docs/server/reference/sql-statements/table-statements/analyze-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Analyze and store key distribution. This statement updates index statistics used by the optimizer to choose the best execution plan.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/j2jXRa6Yn72ACh181A0z" %}
[CHECK TABLE](/docs/server/reference/sql-statements/table-statements/check-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Check tables or views for errors. This statement verifies the integrity of table structure and data for supported storage engines.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/4Hqjx1PrLaTCkvyeBY9X" %}
[CHECK VIEW](/docs/server/reference/sql-statements/table-statements/check-view.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Verify the validity of a view's algorithm. This statement checks if the view definition is correct and references existing tables.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/j17ZyEAHAo9tfs3D5ihq" %}
[CHECKSUM TABLE](/docs/server/reference/sql-statements/table-statements/checksum-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Report a checksum for table contents. This statement calculates a value to compare tables, useful for verifying replication consistency.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/Ro9nVdiya2KDRuCHYUWP" %}
[CREATE TABLE](/docs/server/server-usage/tables/create-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete guide to creating tables in MariaDB. Complete `CREATE TABLE` syntax for data types, constraints, indexes, and storage engines for production use.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/m5441E3tn6YdrYsJpkgW" %}
[DELETE](/docs/server/reference/sql-statements/data-manipulation/changing-deleting-data/delete.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete guide to deleting data in MariaDB. Complete `DELETE` syntax with `WHERE` filtering, `JOIN` operations, and safety considerations for production use.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/UbmyaLXHXBtJIl3r1AIx" %}
[DROP TABLE](/docs/server/server-usage/tables/drop-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete `DROP TABLE` syntax: `TEMPORARY`, `IF EXISTS`, `WAIT`/`NOWAIT`, `RESTRICT`/`CASCADE` options, metadata locks, atomic `DROP`, and replication behavior.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/GDD3FlhmnK6PK3F7NDfm" %}
[INSERT](/docs/server/reference/sql-statements/data-manipulation/inserting-loading-data/insert.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete guide to inserting data in MariaDB. Complete `INSERT` syntax for single rows, bulk operations, and `ON DUPLICATE KEY` handling for production use.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/vLg2ne69yn7hm4MLKrWQ" %}
[OPTIMIZE TABLE](/docs/server/ha-and-performance/optimization-and-tuning/optimizing-tables/optimize-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete MariaDB performance optimization guide. Complete reference for query tuning, indexing strategies, and configuration improvements for production use.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/W4nres4WAm7goiCo8575" %}
[RENAME TABLE](/docs/server/reference/sql-statements/data-definition/rename-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Change the name of one or more tables atomically. This command moves tables within or between databases while preserving their data and structure.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/Pt914S2lVmmss6eMieni" %}
[REPAIR TABLE](/docs/server/reference/sql-statements/table-statements/repair-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Repair corrupted tables. This statement fixes errors in tables for supported storage engines like MyISAM, Aria, and Archive.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/tfRHA7Q6nCHyfKh3SNeS" %}
[REPAIR VIEW](/docs/server/reference/sql-statements/table-statements/repair-view.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Check and correct a view's algorithm. This statement is primarily used by upgrade scripts to ensure view definitions are compatible.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/e9RfzI3eFLmlGIJAe29G" %}
[REPLACE](/docs/server/reference/sql-statements/data-manipulation/changing-deleting-data/replace.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Insert or replace rows based on unique keys. This statement acts like `INSERT`, but if a duplicate key exists, it deletes the old row and inserts the new one.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/ATm7VfKiYb51zD6cmwrx" %}
[SHOW COLUMNS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-columns.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete guide to displaying table columns in MariaDB. Complete `SHOW COLUMNS` syntax with field types, keys, and filtering options for production use.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/w3frIkyu8MrOhTq47fO9" %}
[SHOW CREATE TABLE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Get the SQL statement to recreate a table. This statement shows the complete `CREATE TABLE` syntax, including column definitions and indexes.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/5QXELHlDZEeYv3nX91ph" %}
[SHOW INDEX](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-index.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete `SHOW INDEX` reference: ` SHOW INDEX FROM`` `` `*`tbl_name`* syntax, output fields, and `WHERE`/`LIKE` filters.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/L0HrsJ2b9f3oXMmRbMh3" %}
[TRUNCATE TABLE](/docs/server/reference/sql-statements/table-statements/truncate-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete `TRUNCATE TABLE` reference with `[WAIT n|NOWAIT]` syntax, InnoDB `FOREIGN KEY` constraints, implicit commit, and `AUTO_INCREMENT` reset.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/ymzU1J0bSwFzEOp6Y0a8" %}
[UPDATE](/docs/server/reference/sql-statements/data-manipulation/changing-deleting-data/update.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete `UPDATE` statement guide for MariaDB. Complete syntax reference with `WHERE` conditions, `JOIN` operations, and multi-table updates for production use.
{% endcolumn %}
{% endcolumns %}