DATABASE(), SCHEMA()

Description

DATEBASE() returns the name of the currently-connected database as a VARCHAR type string. DATABASE and SCHEMA are used interchangeably.

Syntax

DATABASE()

SCHEMA()

Example

SELECT DATABASE(), SCHEMA();

;xr

   database()            schema()

============================================

  'demodb'              'demodb'