ContextQMD
Back to Starrocks

ALTER DATABASE

docs/en/sql-reference/sql-statements/Database/ALTER_DATABASE.md

4.1.02.0 KB
Original Source

ALTER DATABASE

ALTER DATABASE configures the properties of the specified database.

:::tip

This operation requires the ALTER privilege on the target database. You can follow the instructions in GRANT to grant this privilege.

:::

Syntax

  1. Set database data quota in B/K/KB/M/MB/G/GB/T/TB/P/PB.

    sql
    ALTER DATABASE <db_name> SET DATA QUOTA <quota>;

  2. Rename a database.

    sql
    ALTER DATABASE <db_name> RENAME <new_db_name>;

  3. Set database replica quota.

    sql
    ALTER DATABASE <db_name> SET REPLICA QUOTA <quota>;

  4. Set database storage volume

    sql
    ALTER DATABASE <db_name> SET ("storage_volume" = "<new_storage_volume_name>");

Note:

plain
- After renaming the database, use REVOKE and GRANT commands to modify the corresponding user permission if necessary.
- The database's default data quota and the default replica quota are 2^63-1.
- The database's default storage volume is the default storage volume when the database is created if the "storage_volume" property is not explicitly provided.

Examples

  1. Set data quota for a database.

    SQL
    ALTER DATABASE example_db SET DATA QUOTA 10995116277760B;
-- The above unit is bytes, equivalent to the following statement.
ALTER DATABASE example_db SET DATA QUOTA 10T;
ALTER DATABASE example_db SET DATA QUOTA 100G;
ALTER DATABASE example_db SET DATA QUOTA 200M;

  2. Rename the database example_db as example_db2.

    SQL
    ALTER DATABASE example_db RENAME example_db2;

  3. Set database replica quota.

    SQL
    ALTER DATABASE example_db SET REPLICA QUOTA 102400;

  4. Set database storage volume.

    SQL
    ALTER DATABASE example_db SET ("storage_volume" = "aws_s3_storage_volume");

References