index_name

Description

Returns an index name, when you provide the index ID, the database ID, and the object on which the index is defined.

Syntax

index_name(dbid, objid, indid)

Parameters

Examples

Example 1

Illustrates the normal usage of this function.

select index_name(db_id("testdb"),
    object_id("testdb...tab_apl"),1)
------------

Example 2

Illustrates the output if the database ID is NULL and you use the current database ID.

select index_name(NULL,object_id("testdb..tab_apl"),1)
--------------------------

Example 3

Displays the table name if the index ID is 0, and the database ID and object ID are valid.

select index_name(db_id("testdb"),
    object_id("testdb..tab_apl"),1)
-----------------------------

Usage

• • index_name uses the current database ID, if you pass a NULL value in the dbid parameter

  • index_name returns NULL if you pass a NULL value in the dbid parameter.

  • index_name returns the object name, if the index ID is 0, and you pass valid inputs for the object ID and the database ID.

Permissions

Any user can execute this function.

See also