xyfsjq commented on code in PR #1927: URL: https://github.com/apache/doris-website/pull/1927#discussion_r1943056290
########## docs/sql-manual/sql-statements/database/ALTER-DATABASE.md: ########## @@ -27,79 +27,70 @@ under the License. ## Description -This statement is used to set properties of the specified database. (administrator only) +This statement is used to set the properties of a specified db, change the db name, and set various quotas for the db. -1) Set the database data quota, the unit is B/K/KB/M/MB/G/GB/T/TB/P/PB +## Syntax ```sql -ALTER DATABASE db_name SET DATA QUOTA quota; +ALTER DATABASE <db_name> RENAME <new_name> +ALTER DATABASE <db_name> SET { DATA | REPLICA | TRANSACTION } QUOTA <quota> +ALTER DATABASE <db_name> SET <PROPERTIES> ("<key>" = "<value>" [, ...]) ``` -2) Rename the database +## Required parameters -```sql -ALTER DATABASE db_name RENAME new_db_name; -``` +** 1. `<db_name>`** +> Database Name Review Comment: done ########## docs/sql-manual/sql-statements/database/ALTER-DATABASE.md: ########## @@ -27,79 +27,70 @@ under the License. ## Description -This statement is used to set properties of the specified database. (administrator only) +This statement is used to set the properties of a specified db, change the db name, and set various quotas for the db. -1) Set the database data quota, the unit is B/K/KB/M/MB/G/GB/T/TB/P/PB +## Syntax ```sql -ALTER DATABASE db_name SET DATA QUOTA quota; +ALTER DATABASE <db_name> RENAME <new_name> +ALTER DATABASE <db_name> SET { DATA | REPLICA | TRANSACTION } QUOTA <quota> +ALTER DATABASE <db_name> SET <PROPERTIES> ("<key>" = "<value>" [, ...]) ``` -2) Rename the database +## Required parameters -```sql -ALTER DATABASE db_name RENAME new_db_name; -``` +** 1. `<db_name>`** +> Database Name -3) Set the quota for the number of copies of the database +** 2. `<new_db_name>`** +> New database name Review Comment: done -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org