ALTER-DATABASE

Name

ALTER DATABASE

Description

This statement is used to set attributes of the specified database. (administrator only)

Set the database data quota, measured in B/K/KB/M/MB/G/GB/T/TB/P/PB

ALTER DATABASE db_name SET DATA QUOTA quota;

Rename the database

ALTER DATABASE db_name RENAME new_db_name;

Set the quota for the number of copies of the database

ALTER DATABASE db_name SET REPLICA QUOTA quota;

Note: After renaming the database, if necessary, use the REVOKE and GRANT commands to modify the corresponding user privileges. The default data quota for databases is 1024GB, and the default replica quota is 1073741824.

Example

Set data quota for the specified database

ALTER DATABASE example_db SET DATA QUOTA 10995116277760;
The above unit is bytes, which is equivalent to
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 to example_db2

ALTER DATABASE example_db RENAME example_db2;

Set replica quota for the specified database

ALTER DATABASE example_db SET REPLICA QUOTA 102400;

Keywords

ALTER,DATABASE,RENAME

Best Practice

SET-PROPERTY ALTER-POLICY