alter replication definition Syntax Change

The alter replication definition syntax has been modified to support quoted identifiers.

alter replication definition replication_definition
{with replicate table named table_owner.]'table_name' | 
add column_name [as replicate_column_name]
       [datatype [null | not null]]
       [map to published_datatype] [quoted],... |
alter columns with column_name
       [as replicate_column_name] [quoted | not quoted],...|
alter columns with column_name
        datatype [null | not null]
        [map to published_datatype],...|
alter columns column_name {quoted | not quoted}
add primary key column_name [, column_name]... |
drop primary key column_name [, column_name]... |
add searchable columns column_name [, column_name]... |
drop searchable columns column_name [, column_name]... |
send standby [off | {all | replication definition} columns] |
replicate {minimal | all} columns | 
replicate_if_changed column_name [, column_name]... |
always_replicate column_name [, column_name]...} |
{with | without} dynamic sql
alter replicate table name {quoted | not quoted}

Example 1

Mark as quoted the table named foo:

alter replication definition repdef
   alter replicate table name “foo” quoted

Example 2

Unmark the column foo_col1:

alter replication definition repdef
   with replicate table named “foo”
   alter columns “foo_col1” not quoted