Thread: What is the scope of a temp table?

I have never created a "temp table" before, because I was not sure when 
the table was available and if or when it would be automaticly dropped.

Could someone let me know becuase I could probaly use them in data 
massaging routines.

Guy

> I have never created a "temp table" before, because I was not sure when 
> the table was available and if or when it would be automaticly dropped.
> 
> Could someone let me know becuase I could probaly use them in data 
> massaging routines.

Temp tables are alive in the current session only. Once the session is
closed, the temp tables created in that session are dropped.

regards,
bhuvaneswaran

Thank you.

That is what I wanted to know.

Guy

A.Bhuvaneswaran wrote:

>>I have never created a "temp table" before, because I was not sure when 
>>the table was available and if or when it would be automaticly dropped.
>>
>>Could someone let me know becuase I could probaly use them in data 
>>massaging routines.
>>    
>>
>
>Temp tables are alive in the current session only. Once the session is
>closed, the temp tables created in that session are dropped.
>
>regards,
>bhuvaneswaran
>  
>
...snip...