Share via

ItemByID Method

  • [アーティクル]

この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。新規の開発作業ではこの機能を使用しないようにし、現在この機能を使用しているアプリケーションは修正することを検討してください。

The ItemByID method extracts a member from a SQL Distributed Management Objects (SQL-DMO) container object such as the Databases collection, using a system-defined component identifier to uniquely identify the container member.

構文

object
.ItemByID(
ID 
) 
as Object

Parts

  • object
    Expression that evaluates to an object in the Applies To list.
  • ID
    Long integer that specifies a system-generated component identifier.

Returns

A reference to the object extracted

解説

The ItemByID method is implemented for SQL-DMO collections containing objects exposing the ID property.

Applies To:

AlertCategories Collection

OperatorCategories Collection

Alerts Collection

Operators Collection

Columns Collection

RemoteServers Collection

Databases Collection

ReplicationDatabases Collection

DBFiles Collection

Rules Collection

Defaults Collection

SQLServers Collection

DistributionArticles Collection

StoredProcedures Collection

FileGroups Collection

Tables Collection

Indexes Collection

TargetServerGroups Collection

JobCategories Collection

TargetServers Collection

JobSchedules Collection

TransArticles Collection

JobSteps Collection

TransPublications Collection

Languages Collection

Triggers Collection

Log Files Collection

UserDefinedDatatypes Collection

MergeArticles Collection

UserDefinedFunctions Collection

MergeDynamicSnapshotJobs Collection

Users Collection

MergePublications Collection

Views Collection

MergeSubsetFilters Collection