ID Property

發行項
12/15/2008

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能，並計劃修改目前使用此功能的應用程式。

The ID property exists for Microsoft SQL Server database, agent, and replication components with defined identifiers.

語法

object
.ID

Parts

object
An expression that evaluates to an object in the Applies To list

Data Type

Long

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetID(LPLONG plID);

備註

The definitions of many SQL Server database, agent, and replication components are implemented as records in SQL Server system tables. Within a system table, one column may be designated as an identifier. An identifier is a value that is unique for all rows in the table. Identifiers are assigned by SQL Server.

The ID property represents a SQL Server component identifier and, by using the ItemByID method, provides an alternate method for selecting a specific SQL Distributed Management Objects (SQL-DMO) object from its containing collection.

The ID property of the ReplicationTable2 object is designed to allow an application to retrieve a table object.

附註：
The ID property can be retrieved using SQL Server 2005, SQL Server 2000, and SQL Server version 7.0.

Applies To:

Alert Object	MergePublication Object
Category Object	MergeSubsetFilter Object
Column Object	Operator Object
ConfigValue Object	RemoteServer Object
Database Object	ReplicationTable2 Object
DBFile Object	Rule Object
DBObject Object	StoredProcedure Object
Default Object	Table Object
DistributionArticle Object	TransArticle Object
DistributionPublication Object	TransPublication Object
FileGroup Object	Trigger Object
Index Object	User Object
Language Object	UserDefinedDatatype Object
LogFile Object	UserDefinedFunction Object
MergeArticle Object	View Object

共用方式為