Best method to add a column to DB - Postet den (1419 Views)
Senior Member
Astralis
Innlegg: 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.<
   
 Sidestørrelse 
Postet den
Forum Admin
HuwR
Innlegg: 20611
20611
just add the column and set the default value shouldn't cause any problems doing it in enterprise manager<
Postet den
Senior Member
Astralis
Innlegg: 1218
1218
Good to hear. Thanks!<
 
Du må legge inn en melding