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)

Syntax

'Declaration
Public Enumeration PreCreationOption
'Usage
Dim instance As PreCreationOption
public enum PreCreationOption
public enum class PreCreationOption
type PreCreationOption
public enum PreCreationOption

Members

Member name Description
None No action is taken on the existing table.
Drop A DROP TABLE statement is executed. This value is required to support SQL Server Compact 3.5 SP2 Subscribers.
Delete A DELETE statement is executed to remove individual rows based on the WHERE clause in the subset filter.
Truncate A TRUNCATE TABLE statement is executed to remove all rows from the table.

Remarks

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.