ALTER TABLE table1 ADD
newcolumn int NULL
GO
should not take that long… What takes a long time is to insert columns in the middle of other columns… b/c then the engine needs to create a new table and copy the data to the new table.
ALTER TABLE table1 ADD
newcolumn int NULL
GO
should not take that long… What takes a long time is to insert columns in the middle of other columns… b/c then the engine needs to create a new table and copy the data to the new table.