ret index på table

Har lige læst følgene svar

No , You cant change the column position using ALTER table statement. The
only solution is:-

1. Create a new table with new structure with identity property
2. Insert data into the new table from actual table (Execlude the col1 which
is identiy)

insert into new_table(col2,col3...coln) select col1,col2,col3...coln from
actual_table

3. Generate Script for indexes and dependant objects
4. Verify all the data are moved successfully
5. Drop the actual table
6. Rename the new_table to actual table using (sp_rename new_table,
actual_table)
7. Create the index in the table (execute the script generated in step-3)


her

http://www.webservertalk.com/message235154.html