If the table is empty, perhaps we can directly truncate this table?

[TCeason]

In some scenarios, users might mistake the fuse table for the tmp table.

Frequent creation and deletion of a certain table result in a huge number of history tables.

I think when databend query knows that there is no data in this table, drop table <table_name> can be rewritten by default as drop table <table_name> all

[TCeason]

cc @drmingdrmer @SkyFan2002 @dantengsky @sundy-li

[drmingdrmer]

I'm not very familiar with the internal table structure, so I'll defer to others with more expertise in this area.

[sundy-li]

+1 for this .

[BohuTANG]

We cannot do that, as it would violate the undrop mechanism. This is user data, and we cannot arbitrarily delete it. Users may need to undrop a table schema, even if it contains no data.