Does anybody know how I can change the default value for a column?
I was trying to remove the default value in order to add the new one
afterwards. This is what I tried:
alter table /table-name/ drop default for /column-name/
alter table /table-name/ alter column /column-name/
(/new-decl-without-default/)
It did not work. I cannot find a solution in the documentation. Maybe
you can help me out?
Thank you,
Johan