> For the complete documentation index, see [llms.txt](https://docs.emobiq.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.emobiq.com/emobiq-server/003-database/002-editing-database.md).

# 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.