How to Add Extra Column In Existing Table?

Hi Satheesh,

You can add an extra column in the CDT by downloading XSD and update your XSD.When you publish the datastore after the CDT is updated,column will be automatically added in the table.

OR,
you can provide alter table script to add column in the DB first and then you can modify your XSD.

Please find more details in the below link.
https://docs.appian.com/suite/help/19.3/Mapping_CDTs_to_Pre-defined_Database_Tables.html#add-new-fields

https://docs.appian.com/suite/help/19.3/Generating_Database_Tables_from_CDTs.html#update

It might be even easier to just add the new field to your CDT in the designer without having to download and update the XSD. Although it used to be common to need XSD, now most properties can be defined right in the CDT designer. Then when you save your CDT, it will give you the DDL script with the alter table statement.

Keep in mind that you must update in both places: update the CDT and the database table. The order you update doesn't matter, but you must verify that it the data store publishes after you make both changes. (Note: if you change the CDT first, then you can publish the data store and it will automatically make the change in the database).

It might be even easier to just add the new field to your CDT in the designer without having to download and update the XSD. Although it used to be common to need XSD, now most properties can be defined right in the CDT designer. Then when you save your CDT, it will give you the DDL script with the alter table statement.

Keep in mind that you must update in both places: update the CDT and the database table. The order you update doesn't matter, but you must verify that it the data store publishes after you make both changes. (Note: if you change the CDT first, then you can publish the data store and it will automatically make the change in the database).

thank you..