Re: How do I drop the created Trigger?
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
Subject
Views
Written By
Posted
3259
May 06, 2005 11:44PM
Re: How do I drop the created Trigger?
2704
May 07, 2005 02:59AM
2608
May 10, 2005 12:21AM
2217
June 26, 2005 11:12PM
2302
July 22, 2005 03:34PM
2255
July 22, 2005 03:51PM
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.