---
title: Editing and Deleting Columns
description: Easily edit and delete columns in data tables to ensure accurate representation, format alignment, and dataset cleanliness for analysis.
---
import { Aside, Steps } from '@astrojs/starlight/components';

# Editing and Deleting Columns

Editing and deleting columns in a data table involves making adjustments to ensure that the data is accurately represented and properly formatted for various analytical activities. This includes renaming columns to better reflect their content, altering data types to align with the data being stored, and adjusting data formats to match specific requirements such as date formats. Deleting columns permanently removes unwanted columns from the data table. This helps to keep your dataset clean and relevant.

## Editing a Column
![Edit Column](/images/Studio/Datasources/Datasource-Configuration/Editing-and-Deleting-Columns/Edit-Column.png)

Editing columns in a data table is an essential process for effective data management and analysis. It involves several key adjustments to ensure data accuracy and proper presentation.

To edit a column in a data table, follow the steps below.
<Steps>  
1. Open the required table in the **Datasource Designer**.  
2. Select the column that you want to **Edit**.  
3. Click on the ellipsis <i class="fa-duotone fa-regular fa-ellipsis"></i> icon next to the column.  
4. Select the option **Edit column** to start modifying your column.  
5. Modify the column details as required.  
    * **Column name** Enter the new name for the column in the “Column name” field.  
    * **Source name** If needed, update the source name in the “Source Name” field.  
    * **Type** Select the appropriate data type for the column from the “Type” dropdown menu.  
6. To save the changes, type the column name as it appears in the “Column name” field in the confirmation text field.  
7. Click on **Validate** to ensure that the column is not linked to any other entities.  
8. Click on **Save** to save the changes made.  
</Steps>

<Aside type="caution">  
When you edit a column name, the change is reflected in all the linked entities.  
</Aside>

## Deleting a Column
![Delete column](/images/Studio/Datasources/Datasource-Configuration/Editing-and-Deleting-Columns/Delete-column.png)
<Steps>  
1. Open the required table in the **Datasource Designer**.  
2. Select the column that you want to **Delete**.  
3. Click on the ellipsis <i class="fa-duotone fa-regular fa-ellipsis"></i> icon next to the column.  
4. Select the option **Delete column**. 
5. To confirm the deletion, type the column name as it appears in the “Column name” field in the confirmation text field.  
</Steps>

<Aside type="caution">  
Deleting a column removes it from the database. Once deleted, the column cannot be retrieved.  
</Aside>