Partager via

ReplicationTable Members

  • Article

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

The following tables list the members exposed by the ReplicationTable type.

Public Constructors

  Nom Description
ReplicationTable Overloaded. Creates a new instance of the ReplicationTable class.

Haut de la page

Public Properties

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

Haut de la page

Public Methods

(see also Protected Methods )

  Nom Description
ms158295.pubmethod(fr-fr,SQL.90).gif CommitPropertyChanges  Sends all the cached property change statements to the instance of Microsoft SQL Server. (inherited from ReplicationObject)
ms158295.pubmethod(fr-fr,SQL.90).gif Decouple  Decouples the referenced replication object from the server. (inherited from ReplicationObject)
ms158295.pubmethod(fr-fr,SQL.90).gif EnumIdentityRangeInfo Returns identity range information about articles based on the table.
ms158295.pubmethod(fr-fr,SQL.90).gif EnumReplicationColumns Returns the columns from the table that can be replicated.
ms158295.pubmethod(fr-fr,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms158295.pubmethod(fr-fr,SQL.90).gif GetHashCode  (inherited from Object )
ms158295.pubmethod(fr-fr,SQL.90).gif GetType  (inherited from Object )
ms158295.pubmethod(fr-fr,SQL.90).gif Load  Loads the properties of an existing object from the server. (inherited from ReplicationObject)
ms158295.pubmethod(fr-fr,SQL.90).gif LoadProperties  Loads the properties of an existing object from the server. (inherited from ReplicationObject)
ms158295.pubmethod(fr-fr,SQL.90).gifms158295.static(fr-fr,SQL.90).gif ReferenceEquals  (inherited from Object )
ms158295.pubmethod(fr-fr,SQL.90).gif Refresh  Reloads the properties of the object. (inherited from ReplicationObject)
ms158295.pubmethod(fr-fr,SQL.90).gif ReplicationAddColumn Adds a column to a table that is already published in one or more publications.
ms158295.pubmethod(fr-fr,SQL.90).gif ReplicationDropColumn Removes a column from a table that is published in one or more publications.
ms158295.pubmethod(fr-fr,SQL.90).gif ToString  (inherited from Object )

Haut de la page

Protected Methods

  Nom Description
ms158295.protmethod(fr-fr,SQL.90).gif CheckValidCreation  (inherited from ReplicationObject )
ms158295.protmethod(fr-fr,SQL.90).gif CheckValidDefinition  (inherited from ReplicationObject )
ms158295.protmethod(fr-fr,SQL.90).gif Finalize  (inherited from Object )
ms158295.protmethod(fr-fr,SQL.90).gif GetChangeCommand  (inherited from ReplicationObject )
ms158295.protmethod(fr-fr,SQL.90).gif GetCreateCommand  (inherited from ReplicationObject )
ms158295.protmethod(fr-fr,SQL.90).gif GetDropCommand  (inherited from ReplicationObject )
ms158295.protmethod(fr-fr,SQL.90).gif InternalRefresh  (inherited from ReplicationObject )
ms158295.protmethod(fr-fr,SQL.90).gif MemberwiseClone  (inherited from Object )

Haut de la page

Voir aussi

Référence

ReplicationTable Class
Microsoft.SqlServer.Replication Namespace

Autres ressources

Publication de données et d'objets de base de données