ALTER DATABASE
Description
Configures the properties of the specified database. (Administrator only)
Syntax
-
Set database data quota in B/K/KB/M/MB/G/GB/T/TB/P/PB.
ALTER DATABASE <db_name> SET DATA QUOTA <quota>;
-
Rename a database.
ALTER DATABASE <db_name> RENAME <new_db_name>;
-
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
-
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; -
Rename the database
example_db
asexample_db2
.ALTER DATABASE example_db RENAME example_db2;
-
Set database replica quota.
ALTER DATABASE example_db SET REPLICA QUOTA 102400;