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
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)view a database named
hdfs_text
from a hms catalogmysql> 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