On 22/9/2006 2:14, "Bob Pawley" <[EMAIL PROTECTED]> wrote: > I am seeking wording for a procedure that will initiate a trigger only after > another trigger has completed its function. In this case I want to drop a > table that is created and used by the first trigger.
Sounds like you should use a temporary table. CREATE TEMP TABLE mytmptable (...... This table will just disappear shortly after your trigger is finished. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster