> For the complete documentation index, see [llms.txt](https://help.iviva.com/lucy/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.iviva.com/lucy/my-work-folders/databases/creating-and-editing-databases/editing-fields-in-a-database.md).

# Editing Fields in a Database

So, when you're dealing with a database, making changes such as modifying, adding, or deleting fields is pretty straightforward. It's just a matter of a few simple steps.

## <mark style="color:blue;">Editing a Field</mark>

To edit fields in a database:

1. On the Lucy app **homepage**, head to the **My Work** tab on the left sidebar.
2. All the folders you have created, as well as those created by others, will be listed.
3. If you cannot locate the folder in the list, type in the folder name under **Search Folders.**
4. Click on the folder you wish to open.
5. Jump to the **Databases** tab.
6. Search and select the **database** you wish to edit fields.
7. Hover over the database and click the **Edit** icon that appears.
8. Select the field you want to edit and enter the new field name.
9. Modify the respective field's data type by selecting a different data type if needed.
10. Once you have made the required modifications, click **Update Database.** All the changes made to the database will be applied.

## <mark style="color:blue;">Adding a New Field</mark>

To add a new field:

1. On the Lucy app **homepage**, head to the **My Work** tab on the left sidebar.
2. &#x20;All the folders you have created, as well as those created by others, will be listed.
3. If you cannot locate the folder in the list, type in the folder name under **Search Folders.**
4. Click on the folder you wish to open.
5. Jump to the **Databases** tab.
6. Search and select your database.
7. Hover over it and click **Edit** icon that appears.
8. Click **Add New Field** button.
9. A blank field and its corresponding type will be included in the field list, allowing you to input the field name and its type.

## <mark style="color:blue;">Deleting a Field</mark>

To delete an existing field in a database:

1. On the Lucy app **homepage**, head to the **My Work** tab on the left sidebar.
2. All the folders you have created, as well as those created by others, will be listed.
3. If you cannot locate the folder in the list, type in the folder name under **Search Folders.**
4. Click on the folder you wish to open.
5. Jump to the **Databases** tab.
6. Search and select your database.
7. Hover over it and click **Edit** icon that appears.
8. Select the field you want to delete and click respective **Delete** button.
9. Click **Update Database.** All the changes made to the database will be applied.

## &#x20;<mark style="color:blue;">Saving the Changes</mark>

Once you've made required modifications to your database fields, you need to save it.

To save the changes:

1. On the Lucy app **homepage**, head to the **My Work** tab on the left sidebar.
2. All the folders you have created, as well as those created by others, will be listed.&#x20;
3. If you cannot locate the folder in the list, type in the folder name under **Search Folders.**&#x20;
4. Click on the folder you wish to open.
5. Jump to the **Databases** tab.
6. Search and select your database.
7. Hover over it and click **Edit** icon that appears.
8. Click **Update Database.**&#x20;