Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
 Posted - 2005-07-19 : 04:30:48
|
| Hello Everyone.Is there any way i can add the new column at the particular ordinal position through query and not through Entp Mangr... Thanks in AdvanceComplicated things can be done by simple thinking |
|
|
AndyB13
Aged Yak Warrior
583 Posts |
Posted - 2005-07-19 : 04:41:33
|
Why do you want to do this? Just add a new column to the "end" via the ALTER TABLE command. Otherwise you will have to create a new table, copy the data, drop/re-apply constraints etcDo it in EM and click the "Save Change Script" icon to see what SQL Server does by adding a new column to a table to anywhere but the end.AndyBeauty is in the eyes of the beerholder  |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-07-19 : 04:54:08
|
| It does not matter the ordinal position of the columnIt can be at any ordinal positionMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Adding the column to particular Ordinal Position