CDT Column type Change

yo have to verify mapping between data store entity and cdt if this throws error then manually have to update db column and verify mapping.

Hi Shrirang,

if that column contains any data then it will not be done. You need to truncate that column and run alter command manually or delete that column and publish your datastore again.

Thanks,
Prashant

Hi shrirangh it's always a good idea to follow the below mention steps in order to change the data type of a table:

1. Write and execute the alter script to truncate the target column (But not the table)
2. Write and execute the alter script to change the column type
3. Edit the cdt directly or via downloaded xsd file and click on save
4. This verifies the data store entity and if all good you will find a success notification.

I don't think, there are any ways to update the column type via appian because if that column has some value then this operation will fail.

Hope this will help.

Hello Shrirang,

You can not change the data type of a column in a database even if your data entity is managed as "automatically update database schema" . You have to download the DDL script after updating the CDT and run it directly on database. Then check the mappings again and publish the data store again.

Hope this clears.

Regards,
Naveen