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.

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

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.

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

Now you can view the newly added column in the app, where you can start updating the details. The newly added column as well as the changes are synced with the source database.

Please exercise caution when adding columns. Once created, they cannot be modified or deleted from the app directly—you must access the database to do so.

PreviousAdd Reference Column NextManage Access

Last updated 3 months ago