SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

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

AddColumnOption Enumeration

SQL Server 2012

Enumerates the options for adding a column to a table published in an existing publication.

Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

public enum AddColumnOption

	Member name	Description
	Some	Include the newly added column only to specified publications.
	All	Include the newly added column to all existing publications in which the underlying table is published.
	None	Do not include the newly added column to any publication in which the underlying table is published.

You use these options for adding a column to a published table when the publication or Subscribers to the publication do not support replication of schema changes. For more information, see Make Schema Changes on Publication Databases.

This namespace, class, or member is supported only in the Microsoft .NET Framework version 2.0.

Thread Safety

Public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Instance members are not guaranteed to be thread-safe.

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

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.