DB_ID function [System]

Returns the database ID number.

Cloud note: Because of tenant database isolation rules, when this function is called in the cloud it returns only information about the current tenant database.

Syntax

DB_ID( [ database-name ] )

Parameters

Returns

Standards and compatibility

Example

The statement returns the value 0, when executed against the SQL Anywhere sample database as the sole database on the server.

SELECT DB_ID( 'demo' );

The following statement returns the value 0 if executed against the only running database.

SELECT DB_ID( );