Home Forums SQL Server 2005 Development Adding a new NOT NULL field to an existing table RE: Adding a new NOT NULL field to an existing table

  • one other approach is to give it a default value, then drop the default constraint.