| Table Columns
|
Select columns and provide information for the following fields in the
Table Columns
grid, if necessary. By default, all columns are selected.
- Column – displays column names for the specified table. This field is read-only.
- Replicate As – specify the name by which you want this column to
be known in the replicate table, which is the table to which this information
is replicated. As a default, this field contains the column name of table to be
replicated. To modify this value, double-click in the field, and enter the new column name.
- Datatype – specify the datatype of the table column. As a
default, this field contains the datatype specified in the DDL defining the
table. To modify this value, enter a datatype or select an existing one.
- Map To – specify the datatype to which you want this column
to be mapped in the replicate table, which is the table to which this
information is replicated. As a default, this field has the column datatype of
the table to be replicated. To modify this value, enter a datatype or select an existing one.
- PKey – specify the columns that comprise the primary key for the replicate table.
By default, the primary key is the same as that for the table in
the primary database.
- Searchable – select for all columns you want to be
searchable in the replicate table.
- Nullible – select for the columns you want to be
nullable in the replicate table. Only columns of type text, image, or raw
object are nullable.
- Replicate If Changed – select for all columns you want to be
replicated in the event of changes to column data. You can select only columns of type text,
image, or raw object.
Click Invert Selection to invert the status for selected columns.
|