CREATE DATABASE

CREATE DATABASE — create a new database

Synopsis

CREATE  DATABASE [ IF NOT EXISTS ] name
 [ FROM  source_database  ]

Description

CREATE DATABASE creates a new Hyper database.

Parameters

IF NOT EXISTS

Do not throw an error if the database cannot be created because a database file with the same name already exists. Note: This statement fails if the already existing file is not a database file.

name

The name of the database to create. The new database will be stored as a file with this name in the default database directory. No default file extension is added, but one can be provided as part of the name. Alternatively, this parameter can also be an absolute or relative path to where the database file should be stored. See examples below.

source_database

If the FROM clause is specified, then the new database will contain a copy of source_database, including the content of all tables and all metadata.

Examples

To create a new database:

CREATE DATABASE mydb;

To create a new database at the specified absolute file path (assuming not restricted to the default database directory):

CREATE DATABASE "/home/johndoe/mydatabase.db";

To create a new database under a specified file path relative to the default database directory:

CREATE DATABASE "other_databases/mytest.db";

To copy a database sales into a new database sales_copy:

CREATE DATABASE sales_copy FROM sales;

Compatibility

There is no CREATE DATABASE statement in the SQL standard. Databases are equivalent to the concept of catalogs, whose creation the SQL standard leaves to the application.