Skip to main content

ALTER DATABASE

Description​

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.

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

  2. Rename a database.

    ALTER DATABASE <db_name> RENAME <new_db_name>;

  3. Set database replica quota.

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

Note:

- 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.

Examples​

  1. Set data quota for a database.

    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.

    ALTER DATABASE example_db RENAME example_db2;

  3. Set database replica quota.

    ALTER DATABASE example_db SET REPLICA QUOTA 102400;

References​