Link Search Menu Expand Document

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';