DB_NAME

Description

This function returns the name of a specified database.(DB_NAME in Transact-SQL).

Sample Source Pattern

Syntax

SQL Server

DB_NAME ( [ database_id ] )  

Snowflake SQL

Snowflake SQL Documentation

CURRENT_DATABASE()

Examples

SQL Server

Code:

SELECT DB_NAME();

Result:

RESULT             |
-------------------+
ADVENTUREWORKS2019 |

Snowflake SQL

Code:

SELECT
CURRENT_DATABASE() /*** MSC-WARNING - MSCEWI4069 - CURRENT_DATABASE function has different behavior in certain cases ***/;

Result:

RESULT             |
-------------------+
ADVENTUREWORKS2019 |

Known issues

1. CURRENT_DATABASE function has different behavior in certain cases

DB_NAME function can be invoked with the database_id parameter, which returns the name of the specified database. Without parameters, the function returns the current database name. However, SnowFlake does not support this parameter and the CURRENT_DATABASE function will always return the current database name.

Related EWIs

• MSCEWI4069: CURRENT_DATABASE function has different behavior in certain cases