# Editing Database

## Create Database & Table

To create a new Database or Table,

1. Highlight the database / table where you want to create it, select on root database to create a new database or select on database / table to create new table. ![](/files/WLLoplWvgrEXoBwA8OTq)
2. Press the **Create** button at the middle of the main section. ![](/files/JuHDlWiSUCsYkTArg7to)
3. Configure database creation. ![](/files/BW32KyqI7vON00WoRMkz)
   * Charset available:
     * **utf8mb4**
     * **latin1**
   * Collation available for **utf8mb4** Charset:
     * **utf8mb4\_general\_ci**
     * **utf8mb4\_unicode\_ci**
   * Collation available for **latin1** Charset:
     * **latin1\_general\_ci**
     * **latin1\_swedish\_ci**
4. The new database will be created inside the root database.
5. Alternatively, press the **Create** button on the top right section while highlighting the database root. The database will be created inside the root database. ![](/files/Lz7wIlWhVp05G2PFZEJJ)
6. To create a table, press the **Create** button at the middle of the main section while highlighting any database that user has created. ![](/files/JuHDlWiSUCsYkTArg7to)
7. Configure table creation. ![](/files/c8YNzmL17arpadYZnH3Y)
   * Engine available:
     * **InnoDB**
     * **MyISAM**
   * Charset available:
     * **utf8mb4**
     * **latin1**
   * Collation available for **utf8mb4** Charset:
     * **utf8mb4\_general\_ci**
     * **utf8mb4\_unicode\_ci**
   * Collation available for **latin1** Charset:
     * **latin1\_general\_ci**
     * **latin1\_swedish\_ci**
8. The new table will be created inside the highlighted database / on top of the highlighted table.
9. Alternatively, press the **Create** button on the top right section while highlighting a database or a table. The table will be created inside the highlighted database / on top of the highlighted table. ![](/files/Z1UOQt5ru2XR14VL4vkY)

## Rename Database & Table

To rename a Database or Table,

1. Highlight the database / table which you want to rename
2. Press the **Rename** button on the top right section. ![](/files/Lz7wIlWhVp05G2PFZEJJ) and for table ![](/files/Z1UOQt5ru2XR14VL4vkY)
3. Enter a new name for the database or table ![](/files/negXAAkigxzrvx6RFPky) and for table ![](/files/7yCOiJobhMcjZOt9XOMg)
4. The new name will then be used.

## Modify Database & Table Configuration

To modify a Database or Table configuration,

1. Highlight the database or table which you want to modify.
2. Press the **Configuration** button on the top right section. ![](/files/Lz7wIlWhVp05G2PFZEJJ) Please notice that configuration button icon for configuring database and table is different: ![](/files/BBz6RgrD6LxPbCOOYQj7) and for table ![](/files/uOeDAcXzS9xyfYBSIh1v)
3. Change the database / table configuration ![](/files/wFb6nlT2HmM5hgOyW32h) For root database configuration these fields could be modified
   * **Host**
   * **Port**
   * **Username**
   * **Password** ![](/files/9EZikRjEErLJYRCorETq) For database configuration these fields could be modified
   * Charset available:
     * **utf8mb4**
     * **latin1**
   * Collation available for **utf8mb4** Charset:
     * **utf8mb4\_general\_ci**
     * **utf8mb4\_unicode\_ci**
   * Collation available for **latin1** Charset:
     * **latin1\_general\_ci**
     * **latin1\_swedish\_ci** ![](/files/kwOC1LC1m6pZqbesnWid) For table configuration these fields could be modified (Please take note that Engine cannot be changed from **InnoDB** to **MyISAM** after a table has been created and has foreign keys linked to it as **MyISAM** does not support foreign keys)
   * Engine available:
     * **InnoDB**
     * **MyISAM**
   * Charset available:
     * **utf8mb4**
     * **latin1**
   * Collation available for **utf8mb4** Charset:
     * **utf8mb4\_general\_ci**
     * **utf8mb4\_unicode\_ci**
   * Collation available for **latin1** Charset:
     * **latin1\_general\_ci**
     * **latin1\_swedish\_ci**
4. Confirm the configuration change. The item configuration will then be updated.

## Delete Database & Table

To delete a Database or a Table,

1. Highlight the database or table which you want to remove.
2. Press the **Delete** button on the top right section. ![](/files/Lz7wIlWhVp05G2PFZEJJ)
3. Confirm the deletion. The item will then be removed.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.emobiq.com/emobiq-server/003-database/002-editing-database.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.