MySQL Forums
Forum List  »  Triggers

Re: drop trigger if exists?
Posted by: Frank McGeough
Date: August 18, 2005 11:05AM

Yep. A simple drop trigger statement works. But I want to provide a script that dba's can run with our product just like I provide for db2, oracle, sql server, sybase enterprise...that checks for the existance of our triggers before drop and then creates the new ones. A drop without the check provides an irritating error message that our users will complain to us about. Ah well. Maybe the exists thing will work in the GA release. Thanks.

Options: ReplyQuote

Written By
August 17, 2005 11:57AM
August 18, 2005 03:28AM
Re: drop trigger if exists?
August 18, 2005 11:05AM
August 19, 2005 05:54AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.