ReplicationTable ReplicationTable ReplicationTable Class

Definition

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

public ref class ReplicationTable sealed : Microsoft::SqlServer::Replication::ReplicationObject, Microsoft::SqlServer::Replication::IReplicationDBObject
public sealed class ReplicationTable : Microsoft.SqlServer.Replication.ReplicationObject, Microsoft.SqlServer.Replication.IReplicationDBObject
Public NotInheritable Class ReplicationTable
Inherits ReplicationObject
Implements IReplicationDBObject
Inheritance
ReplicationTableReplicationTableReplicationTable
Implements

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.

Constructors

ReplicationTable() ReplicationTable() ReplicationTable()

Creates a new instance of the ReplicationTable class.

ReplicationTable(String, String, String, ServerConnection) ReplicationTable(String, String, String, ServerConnection) 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.

Properties

CachePropertyChanges CachePropertyChanges CachePropertyChanges

Gets or sets whether to cache changes made to the replication properties or to apply them immediately.

(Inherited from ReplicationObject)
ConnectionContext ConnectionContext ConnectionContext

Gets or sets the connection to an instance of Microsoft SQL Server.

(Inherited from ReplicationObject)
DatabaseName DatabaseName DatabaseName

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

HasBigIntColumn HasBigIntColumn HasBigIntColumn

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

HasBigIntIdentityColumn HasBigIntIdentityColumn HasBigIntIdentityColumn

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

HasColumnSetColumn HasColumnSetColumn HasColumnSetColumn

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

HasGuidColumn HasGuidColumn HasGuidColumn

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

HasHierarchyidColumn HasHierarchyidColumn HasHierarchyidColumn

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

HasIdentityColumn HasIdentityColumn HasIdentityColumn

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

HasIdentityNotForReplicationColumn HasIdentityNotForReplicationColumn HasIdentityNotForReplicationColumn

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

HasImprecisePKColumn HasImprecisePKColumn HasImprecisePKColumn

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

HasPrimaryKey HasPrimaryKey HasPrimaryKey

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

HasRowVersionColumn HasRowVersionColumn HasRowVersionColumn

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

HasSparseColumn HasSparseColumn HasSparseColumn

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

HasSqlVariantColumn HasSqlVariantColumn HasSqlVariantColumn

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

HasTimestampColumn HasTimestampColumn HasTimestampColumn

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

IsExistingObject IsExistingObject IsExistingObject

Gets whether the object exists on the server or not.

(Inherited from ReplicationObject)
IsFileTable IsFileTable IsFileTable

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

Name Name Name

Gets or sets the name of the table.

OwnerName OwnerName OwnerName

Gets or sets the name of table owner.

PublishedInMerge PublishedInMerge PublishedInMerge

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

PublishedInPeerToPeerPublication PublishedInPeerToPeerPublication PublishedInPeerToPeerPublication

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

PublishedInQueuedTransactions PublishedInQueuedTransactions PublishedInQueuedTransactions

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

SqlServerName SqlServerName SqlServerName

Gets the name of the Microsoft SQL Server instance to which this object is connected.

(Inherited from ReplicationObject)
TableId TableId TableId

Gets the object ID of the table.

UserData UserData UserData

Gets or sets an object property that allows users to attach their own data to the object.

(Inherited from ReplicationObject)

Methods

CheckValidCreation() CheckValidCreation() CheckValidCreation()

Checks the valid replication creation.

(Inherited from ReplicationObject)
CheckValidDefinition(Boolean) CheckValidDefinition(Boolean) CheckValidDefinition(Boolean)

Indicates whether the definition is valid.

(Inherited from ReplicationObject)
CommitPropertyChanges() CommitPropertyChanges() CommitPropertyChanges()

Sends all the cached property change statements to the instance of Microsoft SQL Server.

(Inherited from ReplicationObject)
Decouple() Decouple() Decouple()

Decouples the referenced replication object from the server.

(Inherited from ReplicationObject)
EnumIdentityRangeInfo() EnumIdentityRangeInfo() EnumIdentityRangeInfo()

Returns identity range information about articles based on the table.

EnumReplicationColumns() EnumReplicationColumns() EnumReplicationColumns()

Returns the columns from the table that can be replicated.

GetChangeCommand(StringBuilder, String, String) GetChangeCommand(StringBuilder, String, String) GetChangeCommand(StringBuilder, String, String)

Returns the change command from the replication.

(Inherited from ReplicationObject)
GetCreateCommand(StringBuilder, Boolean, ScriptOptions) GetCreateCommand(StringBuilder, Boolean, ScriptOptions) GetCreateCommand(StringBuilder, Boolean, ScriptOptions)

Returns the create command from the replication.

(Inherited from ReplicationObject)
GetDropCommand(StringBuilder, Boolean) GetDropCommand(StringBuilder, Boolean) GetDropCommand(StringBuilder, Boolean)

Returns the drop command from the replication.

(Inherited from ReplicationObject)
InternalRefresh(Boolean) InternalRefresh(Boolean) InternalRefresh(Boolean)

Initiates an internal refresh from the replication.

(Inherited from ReplicationObject)
Load() Load() Load()

Loads the properties of an existing object from the server.

(Inherited from ReplicationObject)
LoadProperties() LoadProperties() LoadProperties()

Loads the properties of an existing object from the server.

(Inherited from ReplicationObject)
Refresh() Refresh() Refresh()

Reloads the properties of the object.

(Inherited from ReplicationObject)
ReplicationAddColumn(String, String, AddColumnOption, String[], String) ReplicationAddColumn(String, String, AddColumnOption, String[], String) ReplicationAddColumn(String, String, AddColumnOption, String[], String)

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

ReplicationDropColumn(String, String) ReplicationDropColumn(String, String) ReplicationDropColumn(String, String)

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

Applies to