# 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="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2FD6VO4dWHLGX8QKnh8azT%2Fimage.png?alt=media&#x26;token=fab3652c-7b55-481f-be40-93ec9d00c4b4" 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="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2FY0dqxZ4vlhRicJx1cIYE%2Fimage.png?alt=media&#x26;token=819ce99b-d762-465b-8803-bea8517a241a" 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="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2FJJt3y0lpgFpsSvkz7smm%2Fimage.png?alt=media&#x26;token=7b3484b3-c890-418a-9fd2-67d850b21b34" alt=""><figcaption></figcaption></figure>

3. Refresh the Power BI source.

<figure><img src="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2Fb9US86ZTFQPCgYOGhhZ7%2Fimage.png?alt=media&#x26;token=37a811e4-8975-4fd2-904c-6e1bd9f4bd05" alt=""><figcaption><p>Refresh source</p></figcaption></figure>

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

<figure><img src="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2F1SwSJuarnnr10Ke2yjXK%2Fimage.png?alt=media&#x26;token=eae52796-2723-46e2-92f2-76fa907beb35" 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="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2FHS3g6ji43ZF4vl7sOLEX%2Fimage.png?alt=media&#x26;token=a4fc6e70-a703-4b6c-b4a1-e9d01b44224f" 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="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2F9q0Tt3TxT9arG5WTd2vk%2Fimage.png?alt=media&#x26;token=7f356a75-691b-46bc-8d22-752d2c7a6aef" 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="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2FyullRb7Oa3aCWz6najjP%2Fimage.png?alt=media&#x26;token=2223c353-21ac-4f0d-a6cf-41bc940bbffa" 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="https://608526116-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FdpYgiTFFEktmDlcxUGTv%2Fuploads%2FntgpdaXEIew6re95oh41%2Fimage.png?alt=media&#x26;token=6a2bd30a-13fa-4421-a948-a6b8ec96213f" 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 %}