SHOW-CREATE-DATABASE

Name

SHOW CREATE DATABASE

Description

This statement is used to check the creation of the doris database.

Syntax:

SHOW CREATE DATABASE db_name;

Note:

• db_name: The name of the database exists in doris.

Example

1. View the creation of the test database in doris

   mysql> SHOW CREATE DATABASE test;
   +----------+----------------------------+
   | Database | Create Database |
   +----------+----------------------------+
   | test | CREATE DATABASE `test` |
   +----------+----------------------------+
   1 row in set (0.00 sec)

Keywords

 SHOW, CREATE, DATABASE

Best Practice