• Article

ID Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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

Syntax

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);

Remarks

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.

See Also

Reference

ItemByID Method