Having used CREATE OR REPLACE with PROCEDURE, TABLE, TRIGGER and VIEW many times, today i tried to execute CREATE OR REPLACE EVENT, only to find it isn't implemented.
I'd like to see that feature being added to SQL Anywhere, it seems quite a logical step to me.
asked 25 Jul '12, 10:42
A reasonable request. Until it is implemented you could use
DROP EVENT IF EXISTS [owner].eventname;
before the CREATE EVENT [owner].eventname ... code.
answered 25 Jul '12, 10:47