SHOW DATABASE ID

Description

This statement is used to find the corresponding database name based on the database id (only used by administrators)

Syntax

SHOW DATABASE <database_id>

Required parameters

** 1. <database_id>**

Database corresponding id number

Return Value

Column	Description
DbName	Database Name

Permission Control

The user executing this SQL command must have at least the following permissions:

Permissions	Object	Notes
ADMIN_PRIV	The entire cluster	Requires administrative privileges for the entire cluster

Example

• Find the corresponding database name according to the database id

  SHOW DATABASE 10396;

  +------------+
  | DbName     |
  +------------+
  | example_db |
  +------------+