Dragonliu2018 opened a new pull request, #31893: URL: https://github.com/apache/doris/pull/31893
## Proposed changes Issue Number: close #31348 Add a new command or key REMOVE to support delete catalog recycle bin. REMOVE is used similarly to RECOVER, refer to [RECOVER](https://doris.apache.org/zh-CN/docs/sql-manual/sql-reference/Database-Administration-Statements/RECOVER?_highlight=recover). If dbId/tableId/partitionId is not specified, the last dropped db/table/partition with the same name is removed by default. For example: 1. Remove the database by name: ```sql REMOVE DATABASE db_name; ``` 2. Remove the table by name: ```sql REMOVE TABLE [db_name.]table_name; ``` 3. Remove the partition by name: ```sql REMOVE PARTITION partition_name FROM [db_name.]table_name; ``` 4. Remove the database by name and id: ```sql REMOVE DATABASE db_name db_id; ``` ## Further comments If this is a relatively large or complex change, kick off the discussion at [d...@doris.apache.org](mailto:d...@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc... -- 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