Skip to main content

Documentation Index

Fetch the complete documentation index at: https://private-7c7dfe99-page-updates.mintlify.app/llms.txt

Use this file to discover all available pages before exploring further.

Renames databases, tables, or dictionaries. Several entities can be renamed in a single query. Note that the RENAME query with several entities is non-atomic operation. To swap entities names atomically, use the EXCHANGE statement. Syntax 
RENAME [DATABASE|TABLE|DICTIONARY] name TO new_name [,...] [ON CLUSTER cluster]

​
RENAME DATABASE

Renames databases. Syntax 
RENAME DATABASE atomic_database1 TO atomic_database2 [,...] [ON CLUSTER cluster]

​
RENAME TABLE

Renames one or more tables. Renaming tables is a light operation. If you pass a different database after TO, the table will be moved to this database. However, the directories with databases must reside in the same file system. Otherwise, an error is returned. If you rename multiple tables in one query, the operation is not atomic. It may be partially executed, and queries in other sessions may get Table ... does not exist ... error. Syntax 
RENAME TABLE [db1.]name1 TO [db2.]name2 [,...] [ON CLUSTER cluster]
Example 
RENAME TABLE table_A TO table_A_bak, table_B TO table_B_bak;
And you can use a simpler sql: 
RENAME table_A TO table_A_bak, table_B TO table_B_bak;

​
RENAME DICTIONARY

Renames one or several dictionaries. This query can be used to move dictionaries between databases. Syntax 
RENAME DICTIONARY [db0.]dict_A TO [db1.]dict_B [,...] [ON CLUSTER cluster]
See Also