add column in the middle column of the table

Dear All

I need add column in the middle column of the table.
For example,
original have columns a1, b2, c3
now, I wanna add column d4 between b2 and c3

Please give me some suggestions.

My platform have two. One is windows 98 plus access 97. Another one is

windows 2000 server plus SQL Server 2000 (service pack 3)

Alex

Alex

If you go into enterprise manager, select the table right click then design table.

Select the column where you need to insert the new column, right click > insert column. Type the column name, column type and length and if nulls are allowed. Then save

Regard

Richard

|||There was a post on this a few weeks ago. Note that you can only do this from Enterprise manager, not in T-SQL. The only way to do this in T-SQl would be to create a temp table copy of the table with the new column, copy over the data, drop the table, then rename the temp table to the old table name.|||

2alex121: never use * in you queries, specify field list in the insert statements and you will never bothered by such sort of problems.

|||...gone should be the days that we had to take care of the ordinal positions in the entitites.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de