Best method to add a column to DB - Posted (1416 Views)
Senior Member
Astralis
Posts: 1218
1218
I need to add a column with a default integer into the TOPIC and REPLY tables. The REPLY table has 110k rows. The TOPIC table has 5k rows. What is the best method to do this without causing any problems?
I'm using MSSQL Server 2000 and usually access it to edit using Enterprise Manager.<
 Sort direction, for dates DESC means newest first  
 Page size 
Posted
Forum Admin
HuwR
Posts: 20611
20611
just add the column and set the default value shouldn't cause any problems doing it in enterprise manager<
Posted
Senior Member
Astralis
Posts: 1218
1218
Good to hear. Thanks!<
 
You Must enter a message