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
	ReplicationTable()	Creates a new instance of the ReplicationTable class.
	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
	CachePropertyChanges	Gets or sets whether to cache changes made to the replication properties or to apply them immediately. (Inherited from ReplicationObject.)
	ConnectionContext	Gets or sets the connection to an instance of Microsoft SQL Server. (Inherited from ReplicationObject.)
	DatabaseName	Gets or sets the name of the database that contains the replication table.
	HasBigIntColumn	Gets a value that indicates whether or not the table has at least one column of the bigint data type.
	HasBigIntIdentityColumn	Gets a value that indicates whether or not the table has at least one identity column of the bigint data type.
	HasColumnSetColumn	Gets a value that indicates whether the table has a column set defined.
	HasGuidColumn	Gets a value that indicates whether or not the table has at least one globally unique identifier column.
	HasHierarchyidColumn	Gets a value that indicates whether the table has a hierarchyid type column.
	HasIdentityColumn	Gets a value that indicates whether or not the table has at least one identity column.
	HasIdentityNotForReplicationColumn	Gets a value that indicates whether or not the table has an identity column with the NOT FOR REPLICATION option set.
	HasImprecisePKColumn	Gets a value that indicates whether or not an imprecise computed column is used as part of the primary key.
	HasPrimaryKey	Gets a value that indicates whether or not the table has a primary key.
	HasRowVersionColumn	Gets a value that indicates whether or not a column exists in the table with the name msrepl_tran_version.
	HasSparseColumn	Gets a value that indicates whether the table has a column with the SPARSE attribute.
	HasSqlVariantColumn	Gets a value that indicates whether or not the table has a sql_variant type column.
	HasTimestampColumn	Gets a value that indicates whether or not the table has a timestamp type column.
	IsExistingObject	Gets whether the object exists on the server or not. (Inherited from ReplicationObject.)
	IsFileTable	Gets a value that indicates whether the table is a file table.
	Name	Gets or sets the name of the table.
	OwnerName	Gets or sets the name of table owner.
	PublishedInMerge	Gets a value that indicates whether or not the table is published in a merge publication.
	PublishedInPeerToPeerPublication	Gets a value that indicates whether or not the table is published in a peer-to-peer transactional replication topology.
	PublishedInQueuedTransactions	Gets a value that indicates whether or not the table is published by a publication that supports queued updating subscriptions.
	SqlServerName	Gets the name of the Microsoft SQL Server instance to which this object is connected. (Inherited from ReplicationObject.)
	TableId	Gets the object ID of the table.
	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
	CommitPropertyChanges	Sends all the cached property change statements to the instance of Microsoft SQL Server. (Inherited from ReplicationObject.)
	Decouple	Decouples the referenced replication object from the server. (Inherited from ReplicationObject.)
	EnumIdentityRangeInfo	Returns identity range information about articles based on the table.
	EnumReplicationColumns	Returns the columns from the table that can be replicated.
	Equals	(Inherited from Object.)
	GetHashCode	(Inherited from Object.)
	GetType	(Inherited from Object.)
	Load	Loads the properties of an existing object from the server. (Inherited from ReplicationObject.)
	LoadProperties	Loads the properties of an existing object from the server. (Inherited from ReplicationObject.)
	Refresh	Reloads the properties of the object. (Inherited from ReplicationObject.)
	ReplicationAddColumn	Adds a column to a table that is already published in one or more publications.
	ReplicationDropColumn	Removes a column from a table that is published in one or more publications.
	ToString	(Inherited from Object.)

Top

Remarks

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.

See Also

Reference

Microsoft.SqlServer.Replication Namespace

Other Resources

Publish Data and Database Objects