...
4. Now describe the table found in step 2step#2. List down all database column names into google sheet.
| Code Block |
|---|
|
desc DE_E_11280; |
5. Compare the columns listed in step #3 with those present in the database table (step #4 columns) for the form PDAC. The database will have more columns than those present in XML. The additional columns are the candidate columns which were storing the data for the deleted field of the form.
...
| Code Block |
|---|
|
update DE_E_11280 set DE_A_29 = DE_A_24. |
| Column/Table name | Description |
|---|
| DE_E_11280 | Form table name |
| DE_A_24 | Missing/Deleted column identified at step #7 |
| DE_A_29 | New column created at step #8. |