# Create a Database

After deploying your cluster, you are ready to create a database. When creating tables in your database, you can choose between columnstore and rowstore tables, depending on whether your workload is analytical or transactional.

This guide explains how to create a database using the [CREATE DATABASE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/create-database.md) command. After you have set up your database, navigate to the [Choosing a Table Storage Type](https://docs.singlestore.com/db/v9.1/create-a-database/choosing-a-table-storage-type.md) topic for more information on what table storage type will best suit your needs.

## In this section

* [Choosing a Table Storage Type](https://docs.singlestore.com/db/v9.1/create-a-database/choosing-a-table-storage-type.md)
* [Columnstore](https://docs.singlestore.com/db/v9.1/create-a-database/columnstore.md)
* [Creating a Columnstore Table](https://docs.singlestore.com/db/v9.1/create-a-database/creating-a-columnstore-table.md)
* [Configuring the Columnstore to Work Effectively](https://docs.singlestore.com/db/v9.1/create-a-database/configuring-the-columnstore-to-work-effectively.md)
* [Rowstore](https://docs.singlestore.com/db/v9.1/create-a-database/rowstore.md)
* [Understanding Keys and Indexes in SingleStore](https://docs.singlestore.com/db/v9.1/create-a-database/understanding-keys-and-indexes-in-singlestore.md)
* [Understanding Shard Key Selection](https://docs.singlestore.com/db/v9.1/create-a-database/understanding-shard-key-selection.md)
* [Understanding Sort Key Selection](https://docs.singlestore.com/db/v9.1/create-a-database/understanding-sort-key-selection.md)
* [Understanding How Datatype Can Affect Performance](https://docs.singlestore.com/db/v9.1/create-a-database/understanding-how-datatype-can-affect-performance.md)
* [Using JSON](https://docs.singlestore.com/db/v9.1/create-a-database/using-json.md)
* [Multi-Value Hash Index (JSON)](https://docs.singlestore.com/db/v9.1/create-a-database/multi-value-hash-index-json.md)
* [Using Persistent Computed Columns](https://docs.singlestore.com/db/v9.1/create-a-database/using-persistent-computed-columns.md)
* [Other Schema Concepts](https://docs.singlestore.com/db/v9.1/create-a-database/other-schema-concepts.md)
* [Detecting and Resolving Data Skew](https://docs.singlestore.com/db/v9.1/create-a-database/detecting-and-resolving-data-skew.md)
* [Optimizing Table Data Structures](https://docs.singlestore.com/db/v9.1/create-a-database/optimizing-table-data-structures.md)
* [Specifying Unenforced Unique Constraints](https://docs.singlestore.com/db/v9.1/create-a-database/specifying-unenforced-unique-constraints.md)

***

Modified at: May 11, 2026

Source: [/db/v9.1/create-a-database/](https://docs.singlestore.com/db/v9.1/create-a-database/)

(An index of the documentation is available at /llms.txt)