solidDB Help : solidDB reference : SQL: Statements : ALTER REPLICATION PARTITION
  
ALTER REPLICATION PARTITION
ALTER REPLICATION PARTITION name
   {ADD TABLE table‑element [column‑list] [WHERE where‑clause] |
   DROP TABLE table‑element}
where:
table-element::= [[catalog-name.]schema-name.]table-name
column‑list:: = (column‑name [, column‑name …])
where-clause::= column-name (predicate constant | IS [NOT] NULL) [AND where-clause]
predicate::= {= | <> | > | < | >= | <=}
Note This statement replaces the previous ALTER LOGREADER PARTITION statement.
Access requirements
SYS_ADMIN_ROLE role
Usage
Use the ALTER REPLICATION PARTITION statement to change a specified partition table list and WHERE clauses.
Notes
▪ A replication partition can be empty but cannot include non-existing tables.
▪ Dropping any database table implicitly drops the table from all replication partitions where it is included (re-creating the table does not add it back to a partition).
Return values
 
Error code
Description
13011
Table table‑name does not exist
13410
Logreader partition not found
13417
Table not found from Logreader partition
13418
Table already exists in replication partition
13419
Invalid partition filter. Check the syntax, and that operations used in where clause are supported.
13420
Syntax error
Examples
solsql> alter replication partition share2 add table tab2 where ID>10;
Command completed successfully, 0 rows affected.
solsql> alter replication partition share2 add table tab2;
SOLID Table Error 13418: Table already exists in replication partition
solsql> alter replication partition share2 add table tab1 (col_a, col_b);
Command completed successfully, 0 rows affected.
Go up to
SQL: Statements