Returns the name of a database with a given ID number.
DB_NAME( [ database-id ] )
database-id The ID of the database. The database-id must be a numeric expression.
VARCHAR
If no database ID is supplied, the name of the current database is returned.
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.
SQL/2008 Vendor extension.
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 );