Adding Child Tables

For both Publication Service and Subscription Service, the first task for specifying child tables is to add child tables. This task requires two separate procedures. For Publication Service, you have to add child tables for the source table. For Subscription Service, you have to add child tables for the destination table.

1. Click the name of a parent table, and click Add Child table .
2. In the "Table name Pattern" window, specify the search criterion.
3. In the Select table window, select the related child table from the list.
4. (Optional) if you want to add tables from another schema, specify the schema name in the Other Schema field, click Add From Other Schema, and select the related child table from the list.
   To reference an external schema, the default schema must have the proper access privileges. For information on how to grant access privileges to an external schema, see Referencing an External Schema.
5. Optional: If you do not want to select a column of the table, click Next and clear the Use check box next to the column. Then Click Finish.
   By default, all columns of the table are selected.
6. If you want to add another child table to the child table, click the name of the child table and click Add Child table .
7. To add more child tables, repeat Step 1 to Step 5.