CREATE DATABASE

On this page Carat arrow pointing down

The CREATE DATABASE statement creates a new CockroachDB database.

Required Privileges

Only the root user can create databases.

Synopsis

CREATE DATABASE IF NOT EXISTS name opt_with opt_template_clause ENCODING opt_equal non_reserved_word_or_sconst opt_lc_collate_clause opt_lc_ctype_clause

Parameters

Parameter Description
IF NOT EXISTS Create a new database only if a database of the same name does not already exist; if one does exist, do not return an error.
name The name of the database to create, which must be unique and follow these identifier rules.
encoding The CREATE DATABASE statement accepts an optional ENCODING clause for compatibility with PostgreSQL, but UTF-8 is the only supported encoding. The aliases UTF8 and UNICODE are also accepted. Values should be enclosed in single quotes and are case insensitive. Example: CREATE DATABASE bank ENCODING = 'UTF-8'.

Example

Create a Database

> CREATE DATABASE bank;

> SHOW DATABASES;
+----------+
| Database |
+----------+
| bank     |
| system   |
+----------+

Create Fails (Name Already In Use)

> SHOW DATABASES;
+----------+
| Database |
+----------+
| bank     |
| system   |
+----------+
> CREATE DATABASE bank;
pq: database "bank" already exists
> SHOW DATABASES;
+----------+
| Database |
+----------+
| bank     |
| system   |
+----------+
> CREATE DATABASE IF NOT EXISTS bank;

SQL does not generate an error, but instead responds CREATE DATABASE even though a new database wasn't created.

> SHOW DATABASES;
+----------+
| Database |
+----------+
| bank     |
| system   |
+----------+

See Also


Yes No
On this page

Yes No