# How Add Column in Table

**URL:** <https://community.automationedge.com/t/how-add-column-in-table/17509>\
**Category:** Process Studio\
**Tags:** rpa\
**Created:** [February 5, 2026, 12:35pm UTC](https://community.automationedge.com/t/how-add-column-in-table/17509 "2026-02-05T12:35:43Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Yogesh36](https://avatars.discourse-cdn.com/v4/letter/y/f475e1/32.png) [@Yogesh36](https://community.automationedge.com/u/Yogesh36)\
**Post date:** [February 5, 2026, 12:35pm UTC](https://community.automationedge.com/t/how-add-column-in-table/17509/1 "2026-02-05T12:35:43Z")

</div>

How to Add column in existing DB Table

---

<div class="post-metadata">

**Author:** ![discourse\_ai\_spam](https://avatars.discourse-cdn.com/v4/letter/d/c68b51/32.png) [@discourse\_ai\_spam](https://community.automationedge.com/u/discourse_ai_spam)\
**Post date:** [February 5, 2026, 12:35pm UTC](https://community.automationedge.com/t/how-add-column-in-table/17509/2 "2026-02-05T12:35:52Z")

</div>



---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/1X/d0391fd870140264d9a935ab8de4c59ea08dffbc.jpg) [@system](https://community.automationedge.com/u/system)\
**Post date:** [February 13, 2026, 7:26am UTC](https://community.automationedge.com/t/how-add-column-in-table/17509/3 "2026-02-13T07:26:32Z")

</div>



---

<div class="post-metadata">

**Author:** ![AETrainings](https://avatars.discourse-cdn.com/v4/letter/a/2acd7d/32.png) [@AETrainings](https://community.automationedge.com/u/AETrainings)\
**Post date:** [September 30, 2026, 9:37am UTC](https://community.automationedge.com/t/how-add-column-in-table/17509/4 "2026-09-30T09:37:37Z")

</div>

In Process Studio, you can add a new column to an existing database table using-

**Method 1. Using the “Execute SQL Script” Step in a Workflow (.psw)**

If you want to execute a custom `ALTER TABLE` statement directly within a data processing workflow:

1. Drag the **Execute SQL Script** step (from the **Scripting** plugin category) onto your workspace canvas.
2. Double-click to open the step configuration.
3. Select your database **Connection**.
4. In the **SQL script to execute** text box, enter your `ALTER TABLE` statement:

```auto
ALTER TABLE employees ADD phone_number VARCHAR(20);

```

1. Click **OK** to save.
  - _Note:_ If this step is connected to a data stream, ensure it is configured to execute once during initialization or isolated so it does not run repeatedly for every incoming data row.

* * *

**Method 2: Using the “SQL” Process Entry in a Process (.psp)**

If you are orchestrating high-level control flows inside a Process (`.psp`) file rather than a row-by-row workflow:

1. Drag the **SQL** process entry (from the **Scripting** plugin category) onto your process canvas.
2. Select your **Database Connection**.
3. In the **SQL script** area, write your alter statement:

```auto
ALTER TABLE employees ADD phone_number VARCHAR(20);

save and execute the process entry as part of your pre-processing setup

```