MS SQL Server 2000 does not allow columns with Default value constraints to
be altered or dropped. So, is there any way to alteror drop those columns?. The problem
occurs because the DEFAULT clause actually creates a constraint on the
table. This name of this constraint is chosen by SQL Server and will differ
from database to database. (more…)