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
| Parameter | Description |
|---|---|
IF EXISTS | Optional. 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;