[feat.]: drop table purge as MySQL

[longdafeng]

Please check the issue list for the same feature first

• Please checked issue list and confirm this feature is encountered for the first time.
• Please try full text in English and attach precise description.

A full description of the feature and provide some example if the same feature exists in other products, such as mysql

In order to avoid drop table into recyclebin, do as mysql "drop table purge"

Right now, 4.0 doesn't support this feature. 

https://ask.oceanbase.com/t/topic/32900010

Right now, OB support purge database objects.

other information

No response