| Table of Contents |
|---|
| English |
|---|
Problem StatementDuring development, we may be creating and removing fields from our form design. This would eventually lead to having unused columns in the database table. In this exercise, we will discuss how to organize a table structure and eventually remove the unused columns. For the purpose of this exercise, we will be focusing on the table named sample. In Joget's database, the table name is app_fd_sample. |
Understanding the Table Structure
...
We can swiftly open up the form in the form builder by putting replacing the parameters as shown in the screenshot below.
Figure 1: Inspecting the form in form builder.
If you do not have access to the database to execute the SQLs in this article, Joget has a built-in feature to find out the usages of the table too. You may click on "Advanced Tools" > "Table" to find out the usages of the same table name too.
We can only click on "Show Table Usage In Other Apps" too to find out the table's usages of the table in other apps.
...