Check for existence of a trigger
Posted by:
CMS
Date: March 10, 2005 04:23PM
(Using 5.0.2-alpha-max)
For tables, you can conditionally drop them. That is, drop them if they exist, or do nothing if they don't.
For example:
DROP TABLE IF EXISTS `MyTable`;
The DROP TRIGGER statement doesn't seem to support the "IF EXISTS" clause. And since attempting to drop a trigger that does not exist causes a 1360 error (Trigger does not exist) and aborts my script, I can't simply have the script try to drop a trigger without know if it's there or not.
In Oracle, I think I could do a "CREATE OR REPLACE". In SQL Server, I could just peek in the sysobjects table to see if an object exists or not. I don't see anything in MySQL where I can look at the object inventory.
Is this just an oversight because I'm using a pre-release version of MySQL or am I just missing the way to see if a trigger already exists?
Thanks.
Subject
Views
Written By
Posted
Check for existence of a trigger
8566
March 10, 2005 04:23PM
3922
March 10, 2005 10:34PM
3151
March 11, 2005 02:38AM
3055
March 11, 2005 05:42PM
3007
June 26, 2005 11:10PM
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.