Add Database Column

PowerTable lets users add new columns to the source database directly through the app. This feature eliminates the need for users to engage with the database directly, enhancing security and efficiency.

Please ensure you have the required permissions to the database you are connected to, as you are adding a column directly to the source database.

Let us consider the example below where we will add the approver details column to the 'Product SubCategories' table.

1. To add a new column to the source, click on Add Database Column.

Add Database Column

1. Enter the column name and its data type. You can optionally make it a non-nullable column and assign a default value. Then click Save.

Here, we have added the 'Approvers' column with the data type VARCHAR.

Add column name and data type

1. Configure the column properties for the newly added column, as you would for any other columns, and then click Save.

Configuring the added column

1. Now you can view the newly added column in the source database, where you can start updating the details.

Update details

Please note that you cannot delete a column directly from the visual—this must be done from the database.