core: Optimize `DROP TABLE` by dropping the entire tx_table instead of deleting rows individually

[Shubham8287]

Refer to this conversation - #3214 (comment)