Home Forums SQL Server 7,2000 T-SQL Change DEFAULT value for a column RE: Change DEFAULT value for a column
ramses2nd
Hall of Fame
Points: 3720
More actions
December 7, 2005 at 8:47 am
#608192
Generally in this case I would just drop the existing constraint and add the new new one. If you do this through Enterprise manager while running a server trace you will find that this is how it accomplishes this as well.