I know I have to drop any table from a publication before making any changes (ALTER TABLE ...) to the table if the table is in a publication. Do I also have to drop the table if I change any triggers on that table?

asked 10 Jul '12, 16:15

crb's gravatar image

crb
1263310
accept rate: 0%

retagged 11 Jul '12, 09:27

RussC_FromSAP's gravatar image

RussC_FromSAP
1.3k11030

I retagged this question with "sql" and "publication" so it will register with the database people on this forum.

(11 Jul '12, 09:28) RussC_FromSAP
Replies hidden
1

Russ: I'm guessing the answer is "no, you don't have to drop a table from a publication just because you're going to fiddle with triggers on that table"... especially because YOU, the world's foremost expert on MobiLink, don't have an answer, which implies MobiLink doesn't care, which is what the question asked :)

(11 Jul '12, 10:32) Breck Carter

Speaking specifically for the behaviour in SQL Anywhere 12:

Only ALTER TABLE and ALTER PUBLICATION can potentially result in "This operation is only allowed within a synchronization schema change" (SQLCODE -1329). CREATE TRIGGER / ALTER TRIGGER does not.

Some ALTER TABLE operations are allowed on tables with defined publications, without using 'START SYNCHRONIZATION SCHEMA CHANGE' or using 'sp_hook_dbmlsync_schema_change':

  • Add or modify columns if the column is not part of a publication
  • Drop check, constraint, unique, foreign key definitions
  • Change pctfree, replicate, or encrypted clauses
  • Alter a constraint
  • Rename a constraint
  • Rename a column
  • Rename the table

MobiLink (dbmlsync) will only care about the presence of triggers if the "FireTriggers" or "SendTriggers" extended option has been set. These options are only used for generating the upload stream / applying the download stream and otherwise does not affect the normal SQL Anywhere database server operation (outside of dbmlsync).

permanent link

answered 11 Jul '12, 11:14

Jeff%20Albion's gravatar image

Jeff Albion
10.7k171174
accept rate: 24%

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:

×295
×90
×14

question asked: 10 Jul '12, 16:15

question was seen: 1,362 times

last updated: 11 Jul '12, 11:14