> 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. ![](https://489318254-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKpIso420Eq6T1MZWmK3R%2Fuploads%2Fgit-blob-8dfc873065d9cd8c754fded44895b667dbfb8156%2FEditing-list.png?alt=media)
2. Press the **Create** button at the middle of the main section. ![](https://489318254-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKpIso420Eq6T1MZWmK3R%2Fuploads%2Fgit-blob-feb3a94d2f2848ca01dc9f75d9c1dba231f15bd0%2FEditing-create-large.png?alt=media)
3. Configure database creation. ![](https://489318254-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKpIso420Eq6T1MZWmK3R%2Fuploads%2Fgit-blob-f7033cce2ad4d487df3107a2a0dbda6240fc152f%2FEditing-database-create-popup.png?alt=media)
   * 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. ![](https://489318254-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKpIso420Eq6T1MZWmK3R%2Fuploads%2Fgit-blob-0839e5b349a8defccc615ff10badf9b88d7912ff%2FEditing-panel.png?alt=media)
6. To create a table, press the **Create** button at the middle of the main section while highlighting any database that user has created. ![](https://489318254-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKpIso420Eq6T1MZWmK3R%2Fuploads%2Fgit-blob-feb3a94d2f2848ca01dc9f75d9c1dba231f15bd0%2FEditing-create-large.png?alt=media)
7. Configure table creation. ![](https://489318254-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKpIso420Eq6T1MZWmK3R%2Fuploads%2Fgit-blob-eb09e5160fdb2204041e6a8667a4b3fd1c125f5a%2FEditing-table-create-popup.png?alt=media)
   * 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. ![](https://489318254-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKpIso420Eq6T1MZWmK3R%2Fuploads%2Fgit-blob-26c9934115de2e1c640fe244a70ad5229c98c8f8%2FEditing-table-panel.png?alt=media)

## 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. ![](https://489318254-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKpIso420Eq6T1MZWmK3R%2Fuploads%2Fgit-blob-0839e5b349a8defccc615ff10badf9b88d7912ff%2FEditing-panel.png?alt=media) and for table ![](https://489318254-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKpIso420Eq6T1MZWmK3R%2Fuploads%2Fgit-blob-26c9934115de2e1c640fe244a70ad5229c98c8f8%2FEditing-table-panel.png?alt=media)
3. Enter a new name for the database or table ![](https://489318254-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKpIso420Eq6T1MZWmK3R%2Fuploads%2Fgit-blob-75a1fb3f799f3aba9344cde24bb54506691cedc9%2FEditing-rename-popup.png?alt=media) and for table ![](https://489318254-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKpIso420Eq6T1MZWmK3R%2Fuploads%2Fgit-blob-b41ab47284d0ddd98f38fcdbd3c156982369c279%2FEditing-table-rename-popup.png?alt=media)
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. ![](https://489318254-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKpIso420Eq6T1MZWmK3R%2Fuploads%2Fgit-blob-0839e5b349a8defccc615ff10badf9b88d7912ff%2FEditing-panel.png?alt=media) Please notice that configuration button icon for configuring database and table is different: ![](https://489318254-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKpIso420Eq6T1MZWmK3R%2Fuploads%2Fgit-blob-1a139d96a9494b1cb34031be66052e29417c55de%2FEditing-database-configuration-button.png?alt=media) and for table ![](https://489318254-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKpIso420Eq6T1MZWmK3R%2Fuploads%2Fgit-blob-554a14d6210529ed2fcd67c4e7c126682aa4583a%2FEditing-table-configuration-button.png?alt=media)
3. Change the database / table configuration ![](https://489318254-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKpIso420Eq6T1MZWmK3R%2Fuploads%2Fgit-blob-a0c7aa88647f471924baa6bbbdfd6036be9438b3%2FEditing-database-root-configuration-popup.png?alt=media) For root database configuration these fields could be modified
   * **Host**
   * **Port**
   * **Username**
   * **Password** ![](https://489318254-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKpIso420Eq6T1MZWmK3R%2Fuploads%2Fgit-blob-a1eae9e513e81acd61ad616b4d08e16bc7ce68bb%2FEditing-database-configuration-popup.png?alt=media) 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** ![](https://489318254-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKpIso420Eq6T1MZWmK3R%2Fuploads%2Fgit-blob-7be54a9376d14125de11c0c3350803261e95990d%2FEditing-table-configuration-popup.png?alt=media) 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. ![](https://489318254-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKpIso420Eq6T1MZWmK3R%2Fuploads%2Fgit-blob-0839e5b349a8defccc615ff10badf9b88d7912ff%2FEditing-panel.png?alt=media)
3. Confirm the deletion. The item will then be removed.