| Author |
 Topic  |
|
|
Astralis
Senior Member
USA
1218 Posts |
 Posted - 25 April 2008 : 15:56:43
|
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.< |
|
|
HuwR
Forum Admin
United Kingdom
20593 Posts |
Posted - 25 April 2008 : 17:17:36
|
| just add the column and set the default value shouldn't cause any problems doing it in enterprise manager< |
 |
|
|
Astralis
Senior Member
USA
1218 Posts |
Posted - 25 April 2008 : 17:22:35
|
| Good to hear. Thanks!< |
|
|
| |
Topic |
|
Best method to add a column to DB
