ALTER DATABASE
Updates the configuration of the specified database <database_name>
.
Syntax
ALTER DATABASE <database_name> WITH
[ATTACHED_ENGINES = ( '<engine_name>' [, ... ] )]
[DEFAULT_ENGINE = 'engine_name']
[DESCRIPTION = 'description']
Parameter | Description |
---|---|
<database_name> | Name of the database to be altered. |
ATTACHED_ENGINES = <engine_name> | Name(s) of Firebolt engine(s) attached to the database. |
DEFAULT_ENGINE = <engine_name> | Name of the default engine. |
DESCRIPTION = <description> | Description of the database. |
Example
ALTER DATABASE my_database WITH DEFAULT_ENGINE = 'my_new_default_engine';