Re: How to drop a temp table using "if exists" logic ?

Doug Conrey wrote: > Unfortunately, I believe this will find a temporary table by the > specified name in any session on the instance, not just the current one. > Also, as a note, it may return greater than one if the table is > fragmented. > We have also run into this, and would dearly love to see a simple way to > get a list of a session's temp tables. > > DC > onstat -g ses in later versions shows temp tables.