dmreassigntable - Update target table definition

Use this command to update the definition of a target table in CDC Replication metadata after you change the definition of the target table in your database.

Syntax

dmreassigntable [-I <name>] -s <subscription ...> 
 -A|-t <schema>.<table> ... [-L <locale>]

Parameters

[-I <name>]: Specifies the name of the CDC Replication instance. Alternatively, you can specify the TSINSTANCE environment variable in place of this value.
-s <subscription ...>: Specifies the subscription that contains the source table that is mapped to the target table which was updated in your database. To specify multiple subscriptions, list the subscriptions separated by a space.
-A: Specifies that CDC Replication updates definitions for all target tables in the subscription.
-t <schema>.<table> ...: Specifies the name of a source table in the subscription that is mapped to the target table for which CDC Replication updates the table definition in the metadata. You must specify the table name in the format schema.table. To specify multiple tables, list the tables separated by a space.
[-L <locale>]: The name of the locale used for the CDC Replication instance. The default is your machine's locale.

Result

This command returns a value of 0 if the operation was successful. If it fails, this command returns a non-zero value.

Example

dmreassigntable
-I NEWINSTANCE -s FINANCE -A

CDC Replication updates definitions for all target tables in the Finance subscription.

dmreassigntable
-I CDCINSTANCE -s FINANCE -t SCHEMA1.SRCTBL1

CDC Replication updates the definition for the target table that is mapped to the SCHEMA1.SRCTBL1 source table in the Finance subscription.