# Add Database Column

EDITable lets you add new columns to the source database directly from the visual.

1. To add a new column, click on **Manage Columns > Add Database Column.**

<figure><img src="/files/wmpnZBymtftCT62IUOXV" alt=""><figcaption><p>Add Database Column</p></figcaption></figure>

2. In the pop-up window, you can enter the column name and its data type. You can optionally make it a non-nullable column and assign a default value. Then click **Create.**

In the example below, we have added an email ID column with the name 'EmployeeEmailID' and data type VARCHAR.

<figure><img src="/files/TK0rIuBDMAw6Z8HIUAnC" alt=""><figcaption><p>Adding a column to the database</p></figcaption></figure>

After clicking on **Create,** you can see the below toast message.&#x20;

<figure><img src="/files/gTsEcvcAgzDa3RAO0ntZ" alt=""><figcaption></figcaption></figure>

3. Refresh the Power BI source.

<figure><img src="/files/zaFGb2k92plXHvIF8XWc" alt=""><figcaption><p>Refresh source</p></figcaption></figure>

4. The column is now available in the Data pane.

<figure><img src="/files/g5r51gWxQCosyOhHfgnQ" alt=""><figcaption><p>Added column in the Data pane</p></figcaption></figure>

5. Assign it to the 'Columns' field to add it to the EDITable visual.

<figure><img src="/files/XXDNIb4L6KBXxoGRb1UW" alt=""><figcaption><p>Assign the column</p></figcaption></figure>

6. To configure the newly added column, click the highlighted link on the visual.

<figure><img src="/files/LJYJSoQ64TpxQiOiHJc3" alt=""><figcaption><p>Click to configure</p></figcaption></figure>

7. Configure the column properties as you would for any other columns, and then click **Save**.

<figure><img src="/files/bsvlcOhJ2V9UfMDLb0dG" alt=""><figcaption><p>Configuring the added column</p></figcaption></figure>

8. After saving the configuration, go to the 'Home' tab to view the new column added to the source database.

<figure><img src="/files/7FpyB14lychmLlfLluQ0" alt=""><figcaption><p>Added column</p></figcaption></figure>

{% hint style="info" %}
Please note that you cannot delete a column directly from the visual—this must be done from the database. Alternatively, you can simply remove the field from the 'Columns' field well.
{% endhint %}


---

# 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.inforiver.com/editable/working-with-editable/manage-columns/add-database-column.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.