Export (0) Print
Expand All
Expand Minimize

PreCreationOption Enumeration

Enumerates the commands that are executed prior to subscription initialization when a published table already exists in the subscription database.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

public enum PreCreationOption

Member nameDescription
NoneNo action is taken on the existing table.
DropA DROP TABLE statement is executed. This value is required to support SQL Server Compact 3.5 SP1 Subscribers.
DeleteA DELETE statement is executed to remove individual rows based on the WHERE clause in the subset filter.
TruncateA TRUNCATE TABLE statement is executed to remove all rows from the table.

Drop is the default when creating new articles.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft