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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Functions » Alphabetical list of functions

DB_EXTENDED_PROPERTY function [System] Next Page

DB_ID function [System]

Returns the database ID number.


DB_ID( [ database-name ] )


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

See also
Standards and compatibility

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.