# Data Definition Language DDL

## In this section

* [ALTER DATABASE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/alter-database.md)
* [ALTER TABLE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/alter-table.md)
* [ALTER VIEW](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/alter-view.md)
* [ATTACH DATABASE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/attach-database.md)
* [CREATE DATABASE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/create-database.md)
* [CREATE INDEX](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/create-index.md)
* [CREATE MILESTONE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/create-milestone.md)
* [CREATE PROJECTION](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/create-projection.md)
* [CREATE TABLE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/create-table.md)
* [CREATE TABLE with an AUTO\_INCREMENT Column](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/create-table-with-an-auto-increment-column.md)
* [CREATE VIEW](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/create-view.md)
* [DESCRIBE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/describe.md)
* [DETACH DATABASE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/detach-database.md)
* [DROP ... FROM CROSS\_QUERY\_STATS\_CACHE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-from-cross-query-stats-cache.md)
* [DROP … FROM PLANCACHE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-from-plancache.md)
* [DROP DATABASE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-database.md)
* [DROP INDEX](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-index.md)
* [DROP MILESTONE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-milestone.md)
* [DROP PROJECTION](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-projection.md)
* [DROP RESULT TABLE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-result-table.md)
* [DROP TABLE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-table.md)
* [DROP VIEW](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/drop-view.md)
* [FLUSH TABLES](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/flush-tables.md)
* [OPTIMIZE TABLE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/optimize-table.md)
* [TRUNCATE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/truncate.md)
* [UNLOCK TABLES](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/unlock-tables.md)

***

Modified at: May 11, 2026

Source: [/db/v9.1/reference/sql-reference/data-definition-language-ddl/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/)

(An index of the documentation is available at /llms.txt)