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

INT

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