Skip to content

Create a database

This document describes how to use SQL to create a database and the rules that should be followed when creating a database.

Note

Here only a brief description of the CREATE DATABASE statement. For more information, see CREATE DATABASE.

Prepare before starting

Before reading this page, you need to prepare the following:

What is a database

In MatrixOne Intelligence, database objects can contain tables, views and other objects.

Create a database

The CREATE DATABASE statement can be used to create a database.

CREATE DATABASE IF NOT EXISTS `modatabase`;

This statement creates a database named modatabase if it does not exist yet.

To view all databases, execute a SHOW DATABASES statement on the command line:

SHOW DATABASES;

The running result is:

+-------------------------+
| Database |
+-------------------------+
| mo_catalog |
| system |
| system_metrics |
| mysql |
| information_schema |
| modabase |
+-------------------------+

Rules that should be followed when creating a database

  • You can use the CREATE DATABASE statement to create a database and use the USE {databasename}; statement in a SQL session to use the database you created.

  • When a tenant or user creates a new database, role, or child user, only the necessary permissions are granted to the tenant or user, see Access Control in MatrixOne Intelligence.

  • You have prepared the modatabase database and you can add tables to the database, see the next chapter [Create table] (create-table.md).