Creating a Database

Function

This statement is used to create a database.

Syntax

1
2
3

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

Keyword

• IF NOT EXISTS: Prevents system errors if the database to be created exists.
• COMMENT: Describes a database.

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

Parameters

Precautions

• 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.

Example

1. Create a queue. A queue is the basis for using DLI. Before executing SQL statements, you need to create a queue.
2. On the DLI management console, click SQL Editor in the navigation pane on the left. The SQL Editor page is displayed.
3. 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;