> 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/analytics/mariadb-columnstore/reference/data-definition-statements.md).

# ColumnStore Data Definition Statements

- [ColumnStore ALTER TABLE](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-definition-statements/columnstore-alter-table.md): ALTER TABLE for MariaDB ColumnStore modifies existing tables: add, drop, or rename columns and rename tables, with ColumnStore-specific syntax notes for the columnar engine.
- [ColumnStore ALTER VIEW](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-definition-statements/columnstore-alter-view.md): ALTER VIEW for MariaDB ColumnStore changes the definition of an existing view; CREATE OR REPLACE VIEW serves the same purpose with the same syntax.
- [ColumnStore CREATE PROCEDURE](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-definition-statements/columnstore-create-procedure.md): CREATE PROCEDURE for MariaDB ColumnStore defines a stored procedure with named IN, OUT, and INOUT parameters and a routine body containing SQL statements.
- [ColumnStore CREATE TABLE](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-definition-statements/columnstore-create-table.md): CREATE TABLE syntax for MariaDB ColumnStore: defines tables with ENGINE=columnstore, optional compression COMMENT, and standard column-definition syntax for most MariaDB data types.
- [ColumnStore CREATE VIEW](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-definition-statements/columnstore-create-view.md): CREATE VIEW for MariaDB ColumnStore defines a stored query that can be referenced as a virtual table; supports CREATE OR REPLACE VIEW for redefinition.
- [ColumnStore DROP TABLE](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-definition-statements/columnstore-drop-table.md): DROP TABLE for MariaDB ColumnStore deletes a table from the database; the ColumnStore-specific RESTRICT clause limits the drop to the front end for sync purposes.
- [DDL Statements Different in ColumnStore](https://mariadb.com/docs/analytics/mariadb-columnstore/reference/data-definition-statements/ddl-statements-that-differ-for-columnstore.md): DDL statements that behave differently on MariaDB ColumnStore: DROP TABLE RESTRICT, RENAME TABLE cross-database limits, CREATE TABLE engine syntax, and CREATE INDEX restrictions.