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

# ColumnStore Rename Table

The `RENAME TABLE` statement renames one or more ColumnStore tables.

Notes:

* You cannot currently use `RENAME TABLE` to move a table from one database to another.
* See the `ALTER TABLE` syntax for an alternative to `RENAME Table`. The following statement renames the orders table:

```sql
RENAME TABLE orders TO customer_order;
```

The following statement renames both the *orders* table and *customer* table:

```sql
RENAME TABLE orders TO customer_orders,customer TO customers;
```

You may also use `RENAME TABLE` to swap tables. This example swaps the *customer* and *vendor* tables (assuming the *`temp_table`*\
does not already exist):

```sql
RENAME TABLE customer TO temp_table, vendor TO customer,temp_table to vendor;
```

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

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