Export (0) Print
Expand All

ReplicationTable Class

 

Applies To: SQL Server 2016 Preview

Represents information on a table object that is required by replication.

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

System.Object
  Microsoft.SqlServer.Replication.ReplicationObject
    Microsoft.SqlServer.Replication.ReplicationTable

public sealed class ReplicationTable : ReplicationObject, IReplicationDBObject

NameDescription
System_CAPS_pubmethodReplicationTable()

Creates a new instance of the ReplicationTable class.

System_CAPS_pubmethodReplicationTable(String, String, String, ServerConnection)

Creates a new instance of the ReplicationTable class with the specified name and owner, on the specified database, and with the specified connection to an instance of Microsoft SQL Server.

NameDescription
System_CAPS_pubpropertyCachePropertyChanges

Gets or sets whether to cache changes made to the replication properties or to apply them immediately.(Inherited from ReplicationObject.)

System_CAPS_pubpropertyConnectionContext

Gets or sets the connection to an instance of Microsoft SQL Server.(Inherited from ReplicationObject.)

System_CAPS_pubpropertyDatabaseName

Gets or sets the name of the database that contains the replication table.

System_CAPS_pubpropertyHasBigIntColumn

Gets a value that indicates whether or not the table has at least one column of the bigint data type.

System_CAPS_pubpropertyHasBigIntIdentityColumn

Gets a value that indicates whether or not the table has at least one identity column of the bigint data type.

System_CAPS_pubpropertyHasColumnSetColumn

Gets a value that indicates whether the table has a column set defined.

System_CAPS_pubpropertyHasGuidColumn

Gets a value that indicates whether or not the table has at least one globally unique identifier column.

System_CAPS_pubpropertyHasHierarchyidColumn

Gets a value that indicates whether the table has a hierarchyid type column.

System_CAPS_pubpropertyHasIdentityColumn

Gets a value that indicates whether or not the table has at least one identity column.

System_CAPS_pubpropertyHasIdentityNotForReplicationColumn

Gets a value that indicates whether or not the table has an identity column with the NOT FOR REPLICATION option set.

System_CAPS_pubpropertyHasImprecisePKColumn

Gets a value that indicates whether or not an imprecise computed column is used as part of the primary key.

System_CAPS_pubpropertyHasPrimaryKey

Gets a value that indicates whether or not the table has a primary key.

System_CAPS_pubpropertyHasRowVersionColumn

Gets a value that indicates whether or not a column exists in the table with the name msrepl_tran_version.

System_CAPS_pubpropertyHasSparseColumn

Gets a value that indicates whether the table has a column with the SPARSE attribute.

System_CAPS_pubpropertyHasSqlVariantColumn

Gets a value that indicates whether or not the table has a sql_variant type column.

System_CAPS_pubpropertyHasTimestampColumn

Gets a value that indicates whether or not the table has a timestamp type column.

System_CAPS_pubpropertyIsExistingObject

Gets whether the object exists on the server or not.(Inherited from ReplicationObject.)

System_CAPS_pubpropertyIsFileTable

Gets a value that indicates whether the table is a file table.

System_CAPS_pubpropertyName

Gets or sets the name of the table.

System_CAPS_pubpropertyOwnerName

Gets or sets the name of table owner.

System_CAPS_pubpropertyPublishedInMerge

Gets a value that indicates whether or not the table is published in a merge publication.

System_CAPS_pubpropertyPublishedInPeerToPeerPublication

Gets a value that indicates whether or not the table is published in a peer-to-peer transactional replication topology.

System_CAPS_pubpropertyPublishedInQueuedTransactions

Gets a value that indicates whether or not the table is published by a publication that supports queued updating subscriptions.

System_CAPS_pubpropertySqlServerName

Gets the name of the Microsoft SQL Server instance to which this object is connected. (Inherited from ReplicationObject.)

System_CAPS_pubpropertyTableId

Gets the object ID of the table.

System_CAPS_pubpropertyUserData

Gets or sets an object property that allows users to attach their own data to the object. (Inherited from ReplicationObject.)

NameDescription
System_CAPS_pubmethodCommitPropertyChanges()

Sends all the cached property change statements to the instance of Microsoft SQL Server.(Inherited from ReplicationObject.)

System_CAPS_pubmethodDecouple()

Decouples the referenced replication object from the server. (Inherited from ReplicationObject.)

System_CAPS_pubmethodEnumIdentityRangeInfo()

Returns identity range information about articles based on the table.

System_CAPS_pubmethodEnumReplicationColumns()

Returns the columns from the table that can be replicated.

System_CAPS_pubmethodEquals(Object)

(Inherited from Object.)

System_CAPS_pubmethodGetHashCode()

(Inherited from Object.)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_pubmethodLoad()

Loads the properties of an existing object from the server. (Inherited from ReplicationObject.)

System_CAPS_pubmethodLoadProperties()

Loads the properties of an existing object from the server. (Inherited from ReplicationObject.)

System_CAPS_pubmethodRefresh()

Reloads the properties of the object. (Inherited from ReplicationObject.)

System_CAPS_pubmethodReplicationAddColumn(String, String, AddColumnOption, String[], String)

Adds a column to a table that is already published in one or more publications.

System_CAPS_pubmethodReplicationDropColumn(String, String)

Removes a column from a table that is published in one or more publications.

System_CAPS_pubmethodToString()

(Inherited from Object.)

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2015 Microsoft