CREATE (DATABASE|SCHEMA) [IF NOT EXISTS] db_name [COMMENT comment_text] [LOCATION path] [WITH DBPROPERTIES (key=val, ...)]
Create a database. If a database with the same name already exists, an exception is thrown.
IF NOT EXISTS
If a database with the same name already exists, nothing will happen.
If the specified path does not already exist in the underlying file system, this command tries to create a directory with the path.
Specify a property named
key for the database and establish the value for the property respectively as
key already exists, the old value is overwritten with
-- Create database `customer_db`. This throws exception if database with name customer_db -- already exists. CREATE DATABASE customer_db; -- Create database `customer_db` only if database with same name doesn't exist. CREATE DATABASE IF NOT EXISTS customer_db;