Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

It is clear that the database prevents dropping (or replacing) a table which is already participating in a publication.

I don't know why the table name in the message is very odd. Example:

create or replace table mytest (sn int, des varchar(10));--OK
create publication mypub (table mytest);--OK

and then:

drop table mytest
-> Error Table mytest is participating in a publication --OK

create or replace table mytest (sn int, des varchar(10));

-> Error Table TESEYLEFJEYSOVB is participating in a publication --NOK, and every time I get a different table name

asked 09 Nov '22, 06:13

Baron's gravatar image

Baron
2.1k136149177
accept rate: 48%


Can't comment on the wrong table name in the error message...

But you usually will want to use ALTER TABLE here - take care that certain modifications are forbidden/discouraged within a SQL Remote setup, such as dropping/renaming columns or changing from NULL to NOT NULL when nulls might "be around" from outstanding messages.

permanent link

answered 09 Nov '22, 06:39

Volker%20Barth's gravatar image

Volker Barth
40.2k361550822
accept rate: 34%

converted 09 Nov '22, 06:42

both create table statements are identical, I dont want/need to change/alter the table structure.

I just wanted to drop the table and create it within the same statement.

(09 Nov '22, 06:45) Baron
Replies hidden
1

I just wanted to drop the table and create it within the same statement.

But why would you do that if the statements are identical? Certainly not in a running SQL Remote setup...

If this is meant to re-start a test setup, you might just drop the article from the publication before you re-create the table or drop and re-create the publication altogether.

Or start from scratch again - in my experience, a SQL Remote or MobiLink setup "has its history", so if you want to re-start, say after changing the publication design, it might be easier and less error-prone to start with a fresh publication and fresh remotes.

(09 Nov '22, 09:50) Volker Barth
1

Yes, it is meant to re-start a test setup, and Yes I do actually dropping the publication.

Just wanted to report the error.

(09 Nov '22, 10:07) Baron
2

Thank you for reporting this. I am working on a fix.

(09 Nov '22, 11:25) Chris Keating
3

This is fixed in Engineering Case# 827368 and will be in a future patch.

(30 Nov '22, 10:29) Chris Keating
Your answer
toggle preview

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

Question tags:

×4

question asked: 09 Nov '22, 06:13

question was seen: 370 times

last updated: 30 Nov '22, 10:29