---
schema_version: "1"
id: 6b87f734dc035c17cd11f5a41c5528aca9be48c11dcdbbb86603f0c032240747
title: CREATE DATABASE
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-query-guide/references/data-cloud-sql-reference/tableau-sql-commands/create-database.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/create-database.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: c7478f680138edfef99489431bde8fc6c8d66978c148377a7923851c0107ae08
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# CREATE DATABASE

**Applies to:** ❌ Data 360 SQL ✅ Tableau Hyper API

Create a new database.

## Syntax

```sql
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. Even with `IF NOT EXISTS`,
    the `CREATE TABLE` command fails if the already existing file is not a
    Hyper 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 the source database, including the content of all
    tables and all metadata.

## Examples

To create a new database:

```sql
    CREATE DATABASE mydb;
```

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

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

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

```sql
    CREATE DATABASE "other_databases/mytest.db";
```

To copy a database `sales` into a new database `sales_copy`:

```sql
    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.