Hi all,

Good day.

Shubhajyoti, you need to improve your SQL skills, not waste time to create a sp to delete tables.

if you want to create some tmp tables, you can name them like a#t_customer, a#t_sales...

then when you need to delete them, they sit at the top of table list. then just delete them.

You marked them with special name at first place.

What you are doing is not a good habit.

at DBA's view, this is not even acceptable.

have fun.

Ben