Check for existance of a temp table
Hello- Is there a way to check for the existance of a temp table? Thanks Don
↪ replying to don hunt
"don hunt" <dohunt@hotmail.com> wrote in message news:1b56e975.0311121438.745f2c56@posting.google.com...
> Hello-
>
> Is there a way to check for the existance of a temp table?
>
SELECT count(*)
from sysmaster:systabnames s,sysmaster:systabinfo i
where i.ti_partnum = s.partnum
and sysmaster:BITVAL(i.ti_flags,'0x0020') = 1
and s.tabname = 'your_tmp_table_name' ;
The query will return 1 if the temp table exists.