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

  • If any data existing in the table copy the same into a temparory table. Delete the records in the table and alter the table. Insert the records into table from temporary table.