VeloDB Cloud
SQL Manual
SQL Statements
Show
SHOW-CREATE-DATABASE

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:

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

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

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

Keywords

 SHOW, CREATE, DATABASE

Best Practice