OBJECT_NAME Function [System]

Returns the object name.

Syntax

OBJECT_NAME ( object-id [ , database-id ] )

Parameters

Parameter

Description

object-id

The object ID.

database-id

The database ID.

Examples

The following statement returns the name “customer:”

SELECT OBJECT_NAME ( 100209 ) FROM iq_dummy

Standards and Compatibility

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

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

Parent topic: Alphabetical List of Functions
Related reference
BIT_LENGTH Function [String]
BYTE_LENGTH Function [String]
CHAR_LENGTH Function [String]
COL_LENGTH Function [System]
DATALENGTH Function [System]
LEN Function [String]
LENGTH Function [String]
OCTET_LENGTH Function [String]
STR_REPLACE Function [String]
COL_NAME Function [System]
DB_ID Function [System]
DB_NAME Function [System]
DB_PROPERTY Function [System]
NEXT_DATABASE Function [System]
OBJECT_ID Function [System]