DATABASE/SCHEMA Functions

Description

The functions DATABASE and SCHEMA are used interchangeably. They return the name of currently-connected database as a VARCHAR type.

Syntax

DATABASE()

SCHEMA()

Example

SELECT DATABASE(), SCHEMA();

   database()            schema()

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

  'demodb'              'demodb'