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
public enum PreCreationOption
public enum class PreCreationOption
public enum PreCreationOption
public enum PreCreationOption
Members
| Member name | Description |
|---|---|
| Delete | A DELETE statement is executed to remove individual rows based on the WHERE clause in the subset filter. |
| Drop | A DROP TABLE statement is executed. This value is required to support Microsoft SQL Server 2005 Compact Edition Subscribers. |
| None | No action is taken on the existing table. |
| 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.
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.