AnalyticDB:CREATE DATABASE

Creates a database

• Syntax

  CREATE DATABASE [IF NOT EXISTS] db_name          

• Parameter
  db_name: the name of the database. The database name must meet the following requirements:

  • The name can be up to 64 characters in length.
  • The name must start with a lowercase letter.
  • The name can contain letters, digits, and underscores (_).
  • The name cannot contain consecutive underscores (_).
  • The name cannot be the same as that of the built-in analyticdb database.

  Important After you create a database, you cannot modify the name of the database.
• Example

  CREATE DATABASE adb_demo;          

Use a database

You can execute the USE db_name statement to use a database after it is created.

• Syntax

  USE db_name       

• Example

  use adb_demo;
  show tables;
  +------------------------------+
  | Tables_in_adb_demo           |
  +------------------------------+
  | customer                     |
  | test_table                   |