Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.