Help Center> Data Warehouse Service> Tool Guide> DSC - SQL Syntax Migration Tool> SQL Syntax Migration Reference> Oracle Syntax Migration (GaussDB A)> Purge
Purge
In Oracle, the DROP TABLE statement moves a table to the recycle bin. The PURGE statement is used to remove a table or index from the recycle bin and release all of the space associated with the object. This statement also removes the entire recycle bin, or part or all of a dropped tablespace from the recycle bin. The migrated query does not contain PURGE.
Figure 1 Input - Purge
Figure 2 Output - Purge
Parent topic: Oracle Syntax Migration (GaussDB A)
Last Article: Sequences
Next Article: Database Keywords
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.