db_name

Syntax

db_name([database_id])

Parameters

• database_id – is a numeric expression for the database ID (stored in sysdatabases.dbid).

Examples

• Example 1 – Returns the name of the current database:

  select db_name()

• Example 2 – Returns the name of database ID 4:

  select db_name(4)

  ------------------------------ 
  sybsystemprocs

Usage

If you do not specify database_id, db_name returns the name of the current database.

See also Transact-SQL Users Guide.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute db_name.