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?
Coforge DPA
GB
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;
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
Accepted Solution
Coforge DPA
GB
Hi
If that doesnt work then you would need to drop the column and recreate it.
Regards
Bhavya