OBJECT_ID Function [System]

Returns the object ID.

Syntax

OBJECT_ID ( object-name )

Parameters

Parameters

Parameter

Description

object-name

The name of the object.

Examples

The following statement returns the object ID 100209 of the Customers table:

SELECT OBJECT_ID ('CUSTOMERS') FROM iq_dummy

Standards and Compatibility

  • SQL—Vendor extension to ISO/ANSI SQL grammar.

  • Sybase—Adaptive Server Enterprise function implemented for Sybase IQ.

Parent topic: Alphabetical List of Functions
Related reference
COL_NAME Function [System]
DB_ID Function [System]
DB_NAME Function [System]
DB_PROPERTY Function [System]
NEXT_DATABASE Function [System]
OBJECT_NAME Function [System]
INDEX_COL Function [System]