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. |
A reasonable request. Until it is implemented you could use DROP EVENT IF EXISTS [owner].eventname; before the CREATE EVENT [owner].eventname ... code. 1
Thanks, Mark, that's what I'm using now. The enhanced CREATE syntax would be helpfull for a consistent usage: we often generate scripts from sources stored in an version control system. With CREATE OR REPLACE the developers won't have to remember adding the DROP statment.
(25 Jul '12, 11:04)
Reimer Pods
Replies hidden
1
CREATE OR REPLACE EVENT was implemented in SQLA v17 ... Oops, my mistake, I was looking at the v16 docs - the v17 docs are correct: http://dcx.sap.com/index.html#sqla170/en/html/816bb10e6ce21014b9c1ffdd3e67b36f.html*loio816bb10e6ce21014b9c1ffdd3e67b36f
(22 Jul '15, 08:54)
Mark Culp
[NO-MOCKERY-ALLOWED]
(22 Jul '15, 11:49)
Breck Carter
Thanks for implementing this enhancement and shareing the knowledge.
(23 Jul '15, 03:30)
Reimer Pods
FWIW, I was able to install the v17 HTML help (taken form here) without messing up the v16 doc install. They do run side by side as expected.
(23 Jul '15, 07:02)
Volker Barth
|
I agree this would be great.