MySQL Forums
Forum List  »  Triggers

Re: How do I drop the created Trigger?
Posted by: Andrew Gilfrin
Date: May 07, 2005 02:59AM

It's simply

DROP TRIGGER emp.emps_trigger

where emp is the name of the table and emps_trigger is the name of the trigger.

The difficulty comes in that currently there is no information schema for triggers so if you forget the trigger name you can find out what it is to delete it.

If you need more help with triggers check out my site

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

Options: ReplyQuote

Written By
Re: How do I drop the created Trigger?
May 07, 2005 02:59AM

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.