United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2012

Product Documentation

Developer Reference for SQL Server 2012

Developer Reference

Developer's Guide (Replication)

Microsoft.SqlServer.Replication

AddColumnOption Enumeration

AgentJobHistoryInfo Class

AgentProfile Class

AgentProfileParameter Class

AgentProfileParameterInfo Class

AgentProfileTypeOption Enumeration

AgentType Enumeration

Article Class

ArticleConflict Class

ArticleDatatypeMappingOptions Enumeration

ArticleOptions Enumeration

AuthenticationMethod Enumeration

AutomaticReinitializationPolicies Enumeration

BusinessLogicHandler Class

CheckPermissionOptions Enumeration

CommandOptions Enumeration

ConflictPolicyOption Enumeration

ConnectionSecurityContext Class

CreationScriptOptions Enumeration

CustomResolver Class

DatabaseCompatibilityLevel Enumeration

DdlReplicationOptions Enumeration

DistributionArticle Class

DistributionArticleCollection Class

DistributionDatabase Class

DistributionDatabaseCollection Class

DistributionPublication Class

DistributionPublicationCollection Class

DistributionPublisher Class

DistributionPublisherCollection Class

DistributionSubscription Class

DistributionSubscriptionCollection Class

DtsPackageLocationOption Enumeration

FailoverMode Enumeration

FilterTypes Enumeration

HeterogeneousColumn Class

HeterogeneousTable Class

IConnectionSecurityContext Interface

IdentityRangeInfo Class

IdentityRangeManagementOption Enumeration

InitialSyncType Enumeration

IProcessSecurityContext Interface

IReplicationDBObject Interface

LastValidationDateTime Class

LightPublication Class

MergeArticle Class

MergeArticleCollection Class

MergeArticleState Enumeration

MergeConflictCount Class

MergeDynamicSnapshotJob Class

MergeJoinFilter Class

MergePartition Class

MergePublication Class

MergePublicationCollection Class

MergePullSubscription Class

MergePullSubscriptionCollection Class

MergeSessionDetail Class

MergeSessionDetailType Enumeration

MergeSessionError Class

MergeSessionPhase Enumeration

MergeSessionStatus Enumeration

MergeSessionSummary Class

MergeSubscriberMonitor Class

MergeSubscriberType Enumeration

MergeSubscription Class

MergeSubscriptionCollection Class

MonitorCacheRefreshPolicy Enumeration

MonitorThreshold Class

PartitionGroupsOption Enumeration

PartitionOptions Enumeration

PendingCommandInfo Class

PreCreationOption Enumeration

Publication Class

PublicationAccess Class

PublicationArticle Class

PublicationAttributes Enumeration

PublicationCompatibilityLevel Enumeration

PublicationMonitor Class

PublicationMonitorCollection Class

PublicationType Enumeration

PublisherConnectionSecurityContext Class

PublisherMonitor Class

PublisherMonitorCollection Class

PullSubscription Class

QueueOption Enumeration

RegisteredSubscriber Class

RegisteredSubscriberCollection Class

ReplicationAgentSchedule Class

ReplicationBaseCollection Class

ReplicationColumn Class

ReplicationDatabase Class

ReplicationDatabaseCollection Class

ReplicationMonitor Class

ReplicationObject Class

ReplicationSchemaBoundView Class

ReplicationSecurityMode Enumeration

ReplicationServer Class

ReplicationStatus Enumeration

ReplicationStatusAndWarning Class

ReplicationStoredProcedure Class

ReplicationTable Class

ReplicationUserDefinedAggregate Class

ReplicationUserDefinedFunction Class

ReplicationView Class

ReplicationWarnings Enumeration

ResynchronizeType Enumeration

RetentionPeriodUnits Enumeration

ScheduleConstant Enumeration

ScheduleFrequencySubDay Enumeration

ScheduleFrequencyType Enumeration

ScheduleRelativeIntervals Enumeration

ScriptOptions Enumeration

State Enumeration

SubscriberSubscription Class

SubscriberType Enumeration

SubscriberUploadOptions Enumeration

Subscription Class

SubscriptionBackupDeviceType Enumeration

SubscriptionBackupInformation Class

SubscriptionResultOption Enumeration

SubscriptionState Enumeration

SubscriptionSyncType Enumeration

SynchronizationPartner Class

TracerToken Class

TransArticle Class

TransArticleCollection Class

TransConflictCount Class

TransPublication Class

TransPublicationCollection Class

TransPullSubscription Class

TransPullSubscriptionCollection Class

TransSubscriberType Enumeration

TransSubscription Class

TransSubscriptionCollection Class

ValidationMethod Enumeration

ValidationOption Enumeration

VerifyResolverSignatureOption Enumeration

Minimize

This topic has not yet been rated - Rate this topic

PreCreationOption Enumeration

SQL Server 2012

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

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.

Reference

Microsoft.SqlServer.Replication Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.