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 http://www.mysqldevelopment.com

Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog

http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How do I drop the created Trigger?
2487
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.