다음을 통해 공유

ReplicationTables Collection

  • 아티클

Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.

The ReplicationTables collection contains ReplicationTable objects that reference the user-defined tables of a Microsoft SQL Server database.

현재 개체를 보여 주는 SQL-DMO 개체 모델

Properties

Count Property

Methods

Item Method

Refresh Method

주의

SQL Server replication publications and subscriptions can be used to automate replication of user data. To simplify replication configuration when using SQL Distributed Management Objects (SQL-DMO), SQL-DMO implements the ReplicationTables and ReplicationStoredProcedures collections, which list user-defined tables and stored procedures.

With the ReplicationTables collection, you can enumerate those tables that can participate in replication as a source for article data.

When using the Item method, the ReplicationTables collection supports member identification using either name or ordinal reference syntax. For example:

Set oReplicationTable = oReplicationDatabase.oReplicationTables("[Order Details]")

Or:

Set oReplicationTable = oReplicationDatabase.oReplicationTables(3)

Additionally, when using the table name to select an object from the collection, the Item method allows owner name qualification. For example:

Set oReplicationTable = oReplicationDatabase.oReplicationTables("Orders", "dbo")