Description\n-----------\n\nalter\n\nAccess the reference for ALTER statements. This section lists commands to modify existing database objects, including tables, databases, users, and servers.\n\nalter-table\n\nComplete ALTER TABLE guide for MariaDB. Complete syntax for modifying columns, indexes, constraints, and table properties with comprehensive examples.\n\nanalyze-table.md\n\nAnalyze and store key distribution. This statement updates index statistics used by the optimizer to choose the best execution plan.\n\ncheck-table.md\n\nCheck tables or views for errors. This statement verifies the integrity of table structure and data for supported storage engines.\n\ncheck-view.md\n\nVerify the validity of a view's algorithm. This statement checks if the view definition is correct and references existing tables.\n\nchecksum-table.md\n\nReport a checksum for table contents. This statement calculates a value to compare tables, useful for verifying replication consistency.\n\ncreate-table.md\n\nComplete guide to creating tables in MariaDB. Complete CREATE TABLE syntax for data types, constraints, indexes, and storage engines for production use.\n\ndelete.md\n\nComplete guide to deleting data in MariaDB. Complete DELETE syntax with WHERE filtering, JOIN operations, and safety considerations for production use.\n\ndrop-table.md\n\nComplete DROP TABLE syntax: TEMPORARY, IF EXISTS, WAIT/NOWAIT, RESTRICT/CASCADE options, metadata locks, atomic DROP, and replication behavior.\n\ninsert.md\n\nComplete guide to inserting data in MariaDB. Complete INSERT syntax for single rows, bulk operations, and ON DUPLICATE KEY handling for production use.\n\noptimize-table.md\n\nComplete MariaDB performance optimization guide. Complete reference for query tuning, indexing strategies, and configuration improvements for production use.\n\nrename-table.md\n\nChange the name of one or more tables atomically. This command moves tables within or between databases while preserving their data and structure.\n\nrepair-table.md\n\nRepair corrupted tables. This statement fixes errors in tables for supported storage engines like MyISAM, Aria, and Archive.\n\nrepair-view.md\n\nCheck and correct a view's algorithm. This statement is primarily used by upgrade scripts to ensure view definitions are compatible.\n\nreplace.md\n\nInsert 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.\n\nshow-columns.md\n\nComplete guide to displaying table columns in MariaDB. Complete SHOW COLUMNS syntax with field types, keys, and filtering options for production use.\n\nshow-create-table.md\n\nGet the SQL statement to recreate a table. This statement shows the complete CREATE TABLE syntax, including column definitions and indexes.\n\nshow-index.md\n\nComplete SHOW INDEX reference: SHOW INDEX FROM _tbl_name_ syntax, output fields, and WHERE/LIKE filters.\n\ntruncate-table.md\n\nComplete TRUNCATE TABLE reference with [WAIT n|NOWAIT] syntax, InnoDB FOREIGN KEY constraints, implicit commit, and AUTO_INCREMENT reset.\n\nupdate.md\n\nComplete UPDATE statement guide for MariaDB. Complete syntax reference with WHERE conditions, JOIN operations, and multi-table updates for production use.\n\nURL: https://mariadb.com/docs/server/reference/sql-statements/table-statements/README