SHOW-CREATE-DATABASE

Name

SHOW CREATE DATABASE

Description

This statement checks the creation of the doris database, support database from both internal catalog and hms catalog

grammar:

1. SHOW CREATE DATABASE db_name;

illustrate:

• db_name: The name of the database
• if specific a database from hms catalog, will return same with this stmt in hive

Example

1. View the creation of the test database in doris internal catalog

1. mysql> SHOW CREATE DATABASE test; 2. +----------+----------------------------+ 3. | Database | Create Database | 4. +----------+----------------------------+ 5. | test | CREATE DATABASE `test` | 6. +----------+----------------------------+ 7. 1 row in set (0.00 sec) 2. view a database named hdfs_text from a hms catalog

1. mysql> show create database hdfs_text; 2. +-----------+------------------------------------------------------------------------------------+ 3. | Database | Create Database | 4. +-----------+------------------------------------------------------------------------------------+ 5. | hdfs_text | CREATE DATABASE `hdfs_text` LOCATION 'hdfs://HDFS1009138/hive/warehouse/hdfs_text' | 6. +-----------+------------------------------------------------------------------------------------+ 7. 1 row in set (0.01 sec)

Keywords

1. SHOW, CREATE, DATABASE

Best Practice