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
Chandra Sekhara Vyas Dhara
SSChampion
Points: 10207
More actions
January 22, 2008 at 10:02 pm
#770735
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.