Please implement CREATE OR REPLACE EVENT

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.

product-suggestion event

asked 25 Jul '12, 10:42

Reimer Pods
4.5k●38●48●91
accept rate: 11%

I agree this would be great.

(25 Jul '12, 12:14) Siger Matt

flat view

One Answer:

active answers oldest answers newest answers popular answers

A reasonable request. Until it is implemented you could use

DROP EVENT IF EXISTS [owner].eventname;

before the CREATE EVENT [owner].eventname ... code.

permanent link

answered 25 Jul '12, 10:47

Mark Culp
24.8k●10●139●296
accept rate: 41%

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

CREATE OR REPLACE EVENT was implemented in SQLA v17 ... ~~but I see that the documentation did not get updated :-( I have sent a note to the doc team. http://dcx.sap.com/index.html#sa160/en/dbreference/create-event-statement.html~~

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

Well, it is - at least under the "What's New" pages:

alt text

(22 Jul '15, 10:04) Volker Barth

[NO-MOCKERY-ALLOWED] ~~You can avoid opening the wrong docs by using the V17 CHM file instead... which requires you to uninstall the V16 CHM first... gotta love those persistent InstallShield Product Code values. [snork]~~ [/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

showing 2 of 6 show all flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

product-suggestion ×113
event ×41

question asked: 25 Jul '12, 10:42

question was seen: 2,785 times

last updated: 23 Jul '15, 07:02

SAP SQL Anywhere

Please implement CREATE OR REPLACE EVENT

Follow this question

Related questions