Skip to main content

RENAME DICTIONARY

Renames a dictionary.

Syntax

RENAME DICTIONARY [ IF EXISTS ]
[ <catalog_name>. ][ <database_name>. ]<dictionary_name>
TO [ <new_catalog_name>. ][ <new_database_name>. ]<new_dictionary_name>

Parameters

ParameterDescription
IF EXISTSOptional. Suppresses the error if the source dictionary does not exist.
<dictionary_name>The current dictionary name.
<new_dictionary_name>The new dictionary name.

Examples

RENAME DICTIONARY user_info TO user_profile;
RENAME DICTIONARY IF EXISTS default.user_info TO analytics.user_profile;
Try Databend Cloud for FREE

Multimodal, object-storage-native warehouse for BI, vectors, search, and geo.

Snowflake-compatible SQL with automatic scaling.

Sign up and get $200 in credits.

Try it today