DB_NAME function [System]

Returns the name of a database with a given ID number.

Syntax 
DB_NAME( [ database-id  ] )
Parameters

  • database-id   The ID of the database. The database-id must be a numeric expression.

Returns

VARCHAR

Remarks

If no database ID is supplied, the name of the current database is returned.

Standards and compatibility

  • SQL/2003   Vendor extension.

Example

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

SELECT DB_NAME( 0 );
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1