Thank you for all the replies.

The code was working in SQL query.

I wanted to drop the table because the table schema may change so I only need to...