Question
2
Replies
751
Views
Posted: April 8, 2019
Last activity: April 25, 2019
Closed
Solved
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?
Moderation Team has archived post,
Close popover
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Accepted Solution
Posted: 2 years 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