Export (0) Print
Expand All

ReplicationTable Class

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

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

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

public sealed class ReplicationTable : ReplicationObject, 
	IReplicationDBObject

The ReplicationTable type exposes the following members.

  NameDescription
Public methodReplicationTable()Creates a new instance of the ReplicationTable class.
Public methodReplicationTable(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.
Top

  NameDescription
Public propertyCachePropertyChangesGets or sets whether to cache changes made to the replication properties or to apply them immediately. (Inherited from ReplicationObject.)
Public propertyConnectionContextGets or sets the connection to an instance of Microsoft SQL Server. (Inherited from ReplicationObject.)
Public propertyDatabaseNameGets or sets the name of the database that contains the replication table.
Public propertyHasBigIntColumnGets a value that indicates whether or not the table has at least one column of the bigint data type.
Public propertyHasBigIntIdentityColumnGets a value that indicates whether or not the table has at least one identity column of the bigint data type.
Public propertyHasColumnSetColumnGets a value that indicates whether the table has a column set defined.
Public propertyHasGuidColumnGets a value that indicates whether or not the table has at least one globally unique identifier column.
Public propertyHasHierarchyidColumnGets a value that indicates whether the table has a hierarchyid type column.
Public propertyHasIdentityColumnGets a value that indicates whether or not the table has at least one identity column.
Public propertyHasIdentityNotForReplicationColumnGets a value that indicates whether or not the table has an identity column with the NOT FOR REPLICATION option set.
Public propertyHasImprecisePKColumnGets a value that indicates whether or not an imprecise computed column is used as part of the primary key.
Public propertyHasPrimaryKeyGets a value that indicates whether or not the table has a primary key.
Public propertyHasRowVersionColumnGets a value that indicates whether or not a column exists in the table with the name msrepl_tran_version.
Public propertyHasSparseColumnGets a value that indicates whether the table has a column with the SPARSE attribute.
Public propertyHasSqlVariantColumnGets a value that indicates whether or not the table has a sql_variant type column.
Public propertyHasTimestampColumnGets a value that indicates whether or not the table has a timestamp type column.
Public propertyIsExistingObjectGets whether the object exists on the server or not. (Inherited from ReplicationObject.)
Public propertyIsFileTableGets a value that indicates whether the table is a file table.
Public propertyNameGets or sets the name of the table.
Public propertyOwnerNameGets or sets the name of table owner.
Public propertyPublishedInMergeGets a value that indicates whether or not the table is published in a merge publication.
Public propertyPublishedInPeerToPeerPublicationGets a value that indicates whether or not the table is published in a peer-to-peer transactional replication topology.
Public propertyPublishedInQueuedTransactionsGets a value that indicates whether or not the table is published by a publication that supports queued updating subscriptions.
Public propertySqlServerNameGets the name of the Microsoft SQL Server instance to which this object is connected. (Inherited from ReplicationObject.)
Public propertyTableIdGets the object ID of the table.
Public propertyUserDataGets or sets an object property that allows users to attach their own data to the object. (Inherited from ReplicationObject.)
Top

  NameDescription
Public methodCommitPropertyChangesSends all the cached property change statements to the instance of Microsoft SQL Server. (Inherited from ReplicationObject.)
Public methodDecoupleDecouples the referenced replication object from the server. (Inherited from ReplicationObject.)
Public methodEnumIdentityRangeInfoReturns identity range information about articles based on the table.
Public methodEnumReplicationColumnsReturns the columns from the table that can be replicated.
Public methodEquals (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Public methodLoadLoads the properties of an existing object from the server. (Inherited from ReplicationObject.)
Public methodLoadPropertiesLoads the properties of an existing object from the server. (Inherited from ReplicationObject.)
Public methodRefreshReloads the properties of the object. (Inherited from ReplicationObject.)
Public methodReplicationAddColumnAdds a column to a table that is already published in one or more publications.
Public methodReplicationDropColumnRemoves a column from a table that is published in one or more publications.
Public methodToString (Inherited from Object.)
Top

Thread Safety

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.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft