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.