Use the SET DROP command to determine whether
to drop the table space when you drop the database object (replication control
tables, registrations, or subscription-set members).
Note: The drop options affect multiple objects (that is, they are
at the environment-command level), whereas the create options are at an object
level (that is, they are at the task-command level).
Syntax
>>-SET DROP--TARGET--+-ALWAYS-+--------------------------------><
'-NEVER--'
>>-SET DROP--+-CD-------------+--TABLESPACE--+-WHEN EMPTY-+----><
+-CCD------------+ '-NEVER------'
+-TARGET---------+
'-CONTROL TABLES-'
Parameters
- TARGET
- Specifies whether you want to drop the target tables with the subscription.
- ALWAYS
- Always drop the target table.
- NEVER
- Never drop the target table.
- DROP
- Specifies what you want to drop with the subscription.
- CD
- Change data table
- CCD
- Consistent-change-data table
- TARGET
- Target table
- CONTROL TABLES
- Capture, Apply, or Monitor control tables
These options are relevant only for operating-system
environments for which the commands create the table spaces. You can always
specify the drop flag for each of these object types.
- TABLESPACE
- Specifies when to drop the table space that contains the specified object.
- WHEN EMPTY
- Drop the table space only when it is empty.
- NEVER
- Never drop the table space.
Usage notes
The drop subscription-set member command
decides whether to drop an autoregistered target table. If the autoregistration
has dependent subscriptions, the command does not drop the target table and
does not drop the registration; otherwise, the registration and the target
table are dropped only if the SET DROP TARGET ALWAYS command
allows it.
Example 1
To always drop the target table's table space
when the subscription is dropped:
SET DROP TARGET ALWAYS
Example 2
To drop the CCD table space when it is empty:
SET DROP CCD TABLESPACE WHEN EMPTY
SQL Replication