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:
RENAME TABLE orders TO customer_order;The following statement renames both the orders table and customer table:
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):
RENAME TABLE orders TO customer_orders,customer TO customers;RENAME TABLE customer TO temp_table, vendor TO customer,temp_table to vendor;This page is: Copyright © 2025 MariaDB. All rights reserved.