Hi ,

We create Global Temporary table by the syntax

Create Global Temporay table ....

This Global Temp table, people at differnet session can work. One session can not see the data of another session.

But I want to create the table and drop it after it is used. It has to be done inside a stored procedure.

Is it possible to create local temporarytable...? If it is possible all the people can create the local temp table at their own seesion with same name and drop the table after it is used..