The REPL_DBDROPOPTION enum specifies how the subscription is removed.
Members
The following table lists the available values for specifying how the subscription is removed.
Member name |
Value |
Description |
|---|---|---|
LEAVE_DATABASE |
0 |
Removes the subscription, but does not drop the database. |
DROP_DATABASE |
1 |
Removes the subscription and drops the database. |
UNREGISTER_SUBSCRIPTION |
2 |
Unregisters, but does not drop, the subscription. |
Some types of subscription removal have been deprecated in SQL Server 2008 R2. For a complete listing, see Deprecated Features in SQL Server Replication in SQL Server 2008 R2 Books Online.