Re: [GENERAL] dropping non-existent tables

Hello, You can use the information_schema.* tables, which are part of the SQL standard (and thus not proprietary). -Mark. Walsh, Richard (Richard) wrote: Hi, I have a problem in that I need to drop non-existent tables in a DDL script. This is in order that the script can re-build a databas

Re: [GENERAL] Trigger on Update

Hi, Change it to a "BEFORE UPDATE" trigger, and set NEW.updated_date := now(); Otherwise each update produces another update produces another update -Mark. [EMAIL PROTECTED] wrote: Can anybody help me creating a trigger on update trigger with update statement as below. This trigger fir