> 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/ddl-statements-that-differ-for-columnstore.md).

# DDL Statements Different in ColumnStore

In most cases, a ColumnStore table works just as any other MariaDB table. There are, however, a few differences.

The following table lists the data definition statements (DDL) that differ from normal MariaDB [DDL](/docs/server/reference/sql-statements/data-definition.md) when used on ColumnStore tables.

| DDL                                                                                          | Difference                                                                                                                                                                                                                             |
| -------------------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [DROP TABLE](/docs/server/server-usage/tables/drop-table.md)                                 | ColumnStore supports [DROP TABLE ...RESTRICT](/docs/analytics/mariadb-columnstore/reference/data-definition-statements/columnstore-drop-table.md) which only drops the table in the front end.                                         |
| [RENAME TABLE](/docs/server/reference/sql-statements/data-definition/rename-table.md)        | ColumnStore doesn't allow one to rename a table between databases.                                                                                                                                                                     |
| [CREATE TABLE](/docs/server/server-usage/tables/create-table.md)                             | ColumnStore doesn't need indexes, partitions and many other table and column options. See here for [ColumnStore Specific Syntax](/docs/analytics/mariadb-columnstore/reference/data-definition-statements/columnstore-create-table.md) |
| [CREATE INDEX](/docs/server/reference/sql-statements/data-definition/create/create-index.md) | ColumnStore doesn't need indexes. Hence an index many not be created on a table that is defined with engine=columnstore                                                                                                                |

<sub>*This page is: Copyright © 2025 MariaDB. All rights reserved.*</sub>

{% @marketo/form formId="4316" %}