Resolved: Cannot change column with default
3 answers ( 1 marked as helpful)
The column has datatype of INT and hence default has to be of that datatype.
Your query is trying to add 'X' (which is a character) as default to the INT column
thank you!
Hi Izzatilla!
Thanks for reaching out.
As Tanika explained the column has a datatype of INT and hence default has to be of that datatype.
Hope this helps.
Best,
Tsvetelin