Change DB column type
Hello
I created a data type and a property in it (property type decimal). After some time I needed to change the property type from decimal to text.
But when I try to write a value to a data type using an activity, I get the following error. How can I change the column type from decimal to text?
Posted: 1 year ago
Accepted Solution
Posted: 1 year ago
Hi
If that doesnt work then you would need to drop the column and recreate it.
Regards
Bhavya
Hi
You can a query to update the data type of column in DB.
Example query for MS SQL as below:
ALTER TABLE table_name
ALTER COLUMN column_name datatype;
you can then resave the class and db table instances. See if that works.
Regards
Bhavya