DB_ID Function [System]

Returns the database ID number.

Syntax

DB_ID ( [ database-name ] )
Note: CIS functional compensation performance considerations apply.

Parameters

Parameter

Description

database-name

A string expression containing the database name. If database-name is a string constant, it must be enclosed in quotes. If no database-name is supplied, the ID number of the current database is returned

Returns

INT

Standards and Compatibility

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

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

Example

Returns the value 0, if iqdemo is the only running database:

SELECT DB_ID( 'iqdemo' ) FROM iq_dummy

Returns the value 0, if executed against the only running database:

SELECT DB_ID() FROM iq_dummy
Parent topic: Alphabetical List of Functions
Related reference
COL_NAME Function [System]
DB_NAME Function [System]
DB_PROPERTY Function [System]
NEXT_DATABASE Function [System]
OBJECT_ID Function [System]
OBJECT_NAME Function [System]