support drop table SQL

[jimexist]

Is your feature request related to a problem or challenge? Please describe what you are trying to do.

support drop table SQL so that in-memory table created or registered can be dropped.

other external table registered can be either de-registered or not supported (either way, no data is removed from disk)

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.