Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

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

Reimer%20Pods's gravatar image

Reimer Pods
accept rate: 11%


I agree this would be great.

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

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%20Culp's gravatar image

Mark Culp
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.

Oops, my mistake, I was looking at the v16 docs - the v17 docs are correct:*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

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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

Question tags:


question asked: 25 Jul '12, 10:42

question was seen: 2,994 times

last updated: 23 Jul '15, 07:02