View Single Post

   
  #1 (permalink)  
Old 02-29-2008, 06:52 AM
Johan Vervloet
 
Posts: n/a
Default changing the default value for a column

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
Reply With Quote