---
parser: v2
primary_tag: products>sap-hana\,-express-edition
author_name: John Currie
author_profile: https://github.com/JCurrie27
tags: [  tutorial>how-to, tutorial>beginner, products>sap-hana\,-express-edition  ]
time: 15
slug: hxe-ua-dbfundamentals-tenantdb
canonical_url: https://developers.sap.com/tutorials/hxe-ua-dbfundamentals-tenantdb
---
# Create a Tenant Database
<!-- description --> Learn how to complete common tasks when setting up a new database. In this tutorial, you will create a tenant database using either HANA cockpit or an SQL command line.

## Prerequisites
 - [Sample Project](https://developers.sap.com/tutorials/hxe-ua-dbfundamentals-sample-project.html)


## Next Steps
 - [Create a Backup](https://developers.sap.com/tutorials/hxe-ua-dbfundamentals-backups.html)

## You will learn
  - How to create a tenant database using either HANA Cockpit or an SQL command line


---

## Intro
> When creating a tenant database, expect your system to use more memory. Ensure your system has enough memory to run an additional database.

---

### Using SAP HANA Cockpit

> Note:
> This option requires a SAP HANA, express edition Server + Applications installation.

1. Open SAP HANA Cockpit and log in using `XSA_ADMIN`.

2. Open your system database in the __Resource Directory__ window.

3. Under _Tenant Monitoring and Administration_, click _System Running_ in the __Overall Tenant Statuses__ tab to open the __Manage Databases__ page.

    ![Overall Tenant Statuses](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-dbfundamentals-tenantdb/tenantdb_running.png)

4. On the bottom right of the page, click __...__ then _Create Tenant Database_.

    ![Manage Databases Page](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-dbfundamentals-tenantdb/manage_databases.png)

5. Give your tenant database a name and its SYSTEM user a secure password.

    Click _Create Tenant Database_ when you are done.

    ![Create Tenant Database](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-dbfundamentals-tenantdb/Cockpit_createtenantdb.png)

    A message will display that you have successfully created a new tenant database.

    ![Successfully Created Tenant Database](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hxe-ua-dbfundamentals-tenantdb/success.png)


### Using an SQL Command Line

Using SAP HANA studio or another connected SQL console, execute the following command to create a tenant database:

```bash
CREATE DATABASE <database_name> SYSTEM USER PASSWORD <SYSTEM_user_password>
```

Example:

```
CREATE DATABASE TENANTDB SYSTEM USER PASSWORD Password1
```

This creates the tenant database "TENANTDB" with the SYSTEM user password "`Password1`".