"So, in case it does, then i can strongly say that not [10/20/n] user's will be using simultaneously, but infact the DROP TABLE statement may (just may) have not worked." You cannot guarantee that these temp tables aren't being use simultaneously. If, indeed, the DROP TABLE didn't work it's likely due to the tables BEING USED by the various users who created them. It's also, in my opinion, to create multiple tables with completely different structures all named TEMPBOX of some form -- it would be better to name the tables TEMP_(source table name)[some number here] to better identify the base definition and to ensure that no one tries to use a temp table based on EMP, let's say, to try to store data from DEPT. EVeryone has ignored my examples which illustrate that you can have unique table names still based on the submitted base table. I suggest you look at them again.