MySQL Forums
Forum List  »  Triggers

Re: drop trigger if exists?
Posted by: Andrew Gilfrin
Date: August 18, 2005 03:28AM

There is no mention of it in the documentation, I know this wasn't available in the older versions due to the lack of SHOW and INFORMATION_SCHEMA details available.

Can you get drop trigger to work without the if exists?

There was a swtich from triggers being associated with tables directly to them being associated to the database. Therefore the old drop syntax needed a table prefix where the new can have a database prefix (this is not required if you are using the database it's attached to).

I'm running 5.0.7 here so I can't check right now.

Andrew Gilfrin
My MySQL related Blog
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information

Edited 1 time(s). Last edit at 08/18/2005 03:31AM by Andrew Gilfrin.

Options: ReplyQuote

Written By
August 17, 2005 11:57AM
Re: drop trigger if exists?
August 18, 2005 03:28AM
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.