ReplicationTable Class

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

Inheritance Hierarchy

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

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

Syntax

'Declaration
Public NotInheritable Class ReplicationTable _
    Inherits ReplicationObject _
    Implements IReplicationDBObject
'Usage
Dim instance As ReplicationTable
public sealed class ReplicationTable : ReplicationObject, 
    IReplicationDBObject
public ref class ReplicationTable sealed : public ReplicationObject, 
    IReplicationDBObject
[<SealedAttribute>]
type ReplicationTable =  
    class
        inherit ReplicationObject
        interface IReplicationDBObject
    end
public final class ReplicationTable extends ReplicationObject implements IReplicationDBObject

The ReplicationTable type exposes the following members.

Constructors

  Name Description
Public method ReplicationTable() Creates a new instance of the ReplicationTable class.
Public method ReplicationTable(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

Properties

  Name Description
Public property CachePropertyChanges Gets or sets whether to cache changes made to the replication properties or to apply them immediately. (Inherited from ReplicationObject.)
Public property ConnectionContext Gets or sets the connection to an instance of Microsoft SQL Server. (Inherited from ReplicationObject.)
Public property DatabaseName Gets or sets the name of the database that contains the replication table.
Public property HasBigIntColumn Gets whether or not the table has at least one column of the bigint data type.
Public property HasBigIntIdentityColumn Gets whether or not the table has at least one identity column of the bigint data type.
Public property HasColumnSetColumn Gets whether the table has a column set defined.
Public property HasGuidColumn Gets whether or not the table has at least one globally unique identifier column.
Public property HasHierarchyidColumn Gets whether the table has a hierarchyid type column.
Public property HasIdentityColumn Gets whether or not the table has at least one identity column.
Public property HasIdentityNotForReplicationColumn Gets whether or not the table has an identity column with the NOT FOR REPLICATION option set.
Public property HasImprecisePKColumn Gets whether or not an imprecise computed column is used as part of the primary key.
Public property HasPrimaryKey Gets whether or not the table has a primary key.
Public property HasRowVersionColumn Gets whether or not a column exists in the table with the name msrepl_tran_version.
Public property HasSparseColumn Gets whether the table has a column with the SPARSE attribute.
Public property HasSqlVariantColumn Gets whether or not the table has a sql_variant type column.
Public property HasTimestampColumn Gets whether or not the table has a timestamp type column.
Public property IsExistingObject Gets whether the object exists on the server or not. (Inherited from ReplicationObject.)
Public property Name Gets or sets the name of the table.
Public property OwnerName Gets or sets the name of table owner.
Public property PublishedInMerge Gets whether or not the table is published in a merge publication.
Public property PublishedInPeerToPeerPublication Gets whether or not the table is published in a peer-to-peer transactional replication topology.
Public property PublishedInQueuedTransactions Gets whether or not the table is published by a publication that supports queued updating subscriptions.
Public property SqlServerName Gets the name of the Microsoft SQL Server instance to which this object is connected. (Inherited from ReplicationObject.)
Public property TableId Gets the object ID of the table.
Public property UserData Gets or sets an object property that allows users to attach their own data to the object. (Inherited from ReplicationObject.)

Top

Methods

  Name Description
Protected method CheckValidCreation Infrastructure. (Inherited from ReplicationObject.)
Protected method CheckValidDefinition Infrastructure. (Inherited from ReplicationObject.)
Public method CommitPropertyChanges Sends all the cached property change statements to the instance of Microsoft SQL Server. (Inherited from ReplicationObject.)
Public method Decouple Decouples the referenced replication object from the server. (Inherited from ReplicationObject.)
Public method EnumIdentityRangeInfo Returns identity range information about articles based on the table.
Public method EnumReplicationColumns Returns the columns from the table that can be replicated.
Public method Equals (Inherited from Object.)
Protected method Finalize (Inherited from Object.)
Protected method GetChangeCommand Infrastructure. (Inherited from ReplicationObject.)
Protected method GetCreateCommand Infrastructure. (Inherited from ReplicationObject.)
Protected method GetDropCommand Infrastructure. (Inherited from ReplicationObject.)
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Protected method InternalRefresh Infrastructure. (Inherited from ReplicationObject.)
Public method Load Loads the properties of an existing object from the server. (Inherited from ReplicationObject.)
Public method LoadProperties Loads the properties of an existing object from the server. (Inherited from ReplicationObject.)
Protected method MemberwiseClone (Inherited from Object.)
Public method Refresh Reloads the properties of the object. (Inherited from ReplicationObject.)
Public method ReplicationAddColumn Adds a column to a table that is already published in one or more publications.
Public method ReplicationDropColumn Removes a column from a table that is published in one or more publications.
Public method ToString (Inherited from Object.)

Top

Remarks

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

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.

Thread Safety

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