> 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/004-table-relations.md).

# Table Relations

## Create Table Relations

To create a new Table Relations,

1. Highlight the table which you want to add a relations to, then select the **Relations** tab. ![](/files/ncnqFkVrB8lqIwocF7qK)
2. Press the **Add** button located inside the table relations section. ![](/files/N1ltXDeOcMKzYoWl0ezN)
3. A new table relation will be added with several empty / default value fields inside. ![](/files/3wHAAR4ahN8KiC9vC7O1)
   * Available fields:
     * **Name**
     * **Field**
     * **Foreign Table**
     * **Foreign Field**

## Modifying Table Relations

To modify a Table Relations,

1. Highlight the table which relations you want to modify, then select the **Relations** tab.
2. Select the field that you want to modify
   * Available fields:
     * **Name**
     * **Field**
     * **Foreign Table**
     * **Foreign Field**
3. Modifying the **Name** field Type on the field to modify the **Name** value
4. Modifying the **Field** field Select on the dropdown field to modify the **Field** value
   * Notes for **Field** field:
     * The selections are based from the current table structure data, which can be modified by selecting the **Structure** tab.
     * Cannot be empty
     * Empty by default
5. Modifying the **Foreign Table** field Select on the dropdown field to modify the **Foreign Table** value
   * Notes for **Foreign Table** field:
     * The selections are based from all the tables which belong in the same database with the current table
     * Cannot be empty
     * Empty by default
6. Modifying the **Foreign Field** field Select on the dropdown field to modify the **Foreign Field** value
   * Notes for **Foreign Field** field:
     * The selections are based from the table structures which belong to the table that has been selected as the **Foreign Table** value
     * Cannot be empty
     * Empty by default

## Delete Table Relations

To delete a Table Relations,

1. Highlight the table which relations you want to delete, then select the **Relations** tab.
2. Press the **Delete** button on the right side of a relation that need to be removed. ![](/files/EK5MdyWBE1MkUlmNbyIb)