Monday 25 May 2009

Dumping an Application Engine's Temp Tables List

Recently I had an issue to look at that required me to list the temporary tables used by the TL Admin application engine. To do this I used the following SQL: -


select *
from PSAEAPPLTEMPTBL
where AE_APPLID = 'TL_TIMEADMIN'

No comments: