Creating a Database

This statement is used to create a database.

    
         CREATE [DATABASE | SCHEMA] [IF NOT EXISTS] db_name
  [COMMENT db_comment]
  [WITH DBPROPERTIES (property_name=property_value, ...)];

DBPROPERTIES: Specifies database attributes. The attribute name and attribute value appear in pairs.

**Table 1** Parameters
Parameter	Description
db_name	Database name, which consists of letters, digits, and underscores (_). The value cannot contain only digits or start with a digit or underscore (_).
db_comment	Database description
property_name	Database property name
property_value	Database property value

DATABASE and SCHEMA can be used interchangeably. You are advised to use DATABASE.
The default database is a built-in database. You cannot create a database named default.

For details about the complete process for submitting SQL jobs, see Submitting a SQL Job..

Create a queue. A queue is the basis for using DLI. Before executing SQL statements, you need to create a queue. For details, see Creating a Queue.
On the DLI management console, click SQL Editor in the navigation pane on the left. The SQL Editor page is displayed.
In the editing window on the right of the SQL Editor page, enter the following SQL statement for creating a database and click Execute. Read and agree to the privacy agreement, and click OK.
If database testdb does not exist, run the following statement to create database testdb:
1

CREATE DATABASE IF NOT EXISTS testdb;