solidDB Help : Replication : C Replicator : Managing replication : SQL in source database
  
SQL in source database
In C Replicator (CREP), use the following SQL statements in the source database to manage replication partitions and the tables inside the partitions:
CREATE REPLICATION PARTITION, see CREATE REPLICATION PARTITION
DROP REPLICATION PARTITION, see DROP REPLICATION PARTITION
ALTER REPLICATION PARTITION, see ALTER REPLICATION PARTITION
LIST REPLICATION PARTITION, see LIST
DESCRIBE REPLICATION PARTITION, see DESCRIBE REPLICATION
The following rules are associated with replication partitions:
Replication partition commands are transactional and must be committed in order to take effect. Unless committed, the result of the command is not visible to other database users, including the replication process.
Dropping any database table implicitly drops the table from all replication partitions where the table is included and re-creating the table does not re-add the table to the partition.
A replication partition can be empty but it cannot include tables that do not exist in the database; any attempt to create a replication partition (with a table that does not exist) generates the following error:
13011 Table table-name does not exist
Go up to
Managing replication