Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSDN Library

PreCreationOption Enumeration

 

Applies To: SQL Server 2016 Preview

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
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 SQL Server Compact Subscribers.

None

No action is taken on the existing table.

Truncate

A 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.

Return to top

Community Additions

Show:
© 2015 Microsoft