Modify Type for a field in CDT as well as in MySQL

The CDT code would have been helpful to help you. From your question, I suppose that you have changed the columnDefinition in the cdt from int(11) to varchar(255). To verify datastore, you will have to update the table in the database with varchar(255) for that particular field and then try to verify the datastore. Also, make sure that the xsd:type is string. Please let me know if this helps.

Since the column defination of data base table and cdt is different, it will not verify. Go to data base change column from int to varchar and try to verify from appian

if you are using the same column in any query entity , please make sure to update it as well

When you fail to verify the data store there will be a link stating 'more info'. Have a look at what this says

If the DB table has data in it, then following is the practice that should be made:
1) Create a backup table, copy all the data from the main table to backup table.
2) delete all records from the main table
3) alter the table column to varchar(255)
4) Now Insert all the data from backup table to main table.

5) Now go in Appian, under Data types, open the cdt corresponding to the table and hit "Create new version from XSD". Once this is updated, check outdated dependents.

You are all set.

I will agree with gaurava322.

1. If there is no data in table you can:

Drop the table in MySql and then change the XSD of the CDT with proper annotation for the column and table name. Verify the entity and will create the table.

2. If there is data in table:

Create a temp table and move the data from the main table to it. Delete all the rows from the main table and alter the column definition. Move the data back from temp table and deop the temp table.

Please refer the following link, it may helpful.
forum.appian.com/.../Custom_Data_Types.html

Thanks everyone for responding so quickly. One of my other CDT was referencing the same Data field. It works now!