Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - SQL Reference » SQL functions » Functions

DB_ID function [System]

Returns the database ID number.

Syntax
DB_ID( [ database-name ] )
Parameters
  • database-name

    A string containing the database name. If no database-name is supplied, the ID number of the current database is returned.

Returns

INT

Remarks

None

Privileges

None

Standards
  • ANSI/ISO SQL Standard

    Not in the standard.

Example

The following statement returns the value 0, when executed against the 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( );