How to add a new column to a table in between the existing columns in SQL Server 2005 or 2000?

Question

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

David Burrows SSC Guru Points: 65144 More actions · Answer 1

Why? What purpose will it serve?

However, use Enterprise Manager (2000) or Management Studio (2005)

Or

Drop indexes and contraints on the table

Rename the table

Recreate the table with the additional column

Populate the new table with data from renamed table

Recreate indexes and constarints on the new table

Drop renamed table (once new table is OK)

(p.s. this what EM effectively does anyway)

Far away is close at hand in the images of elsewhere.
Anon.