| Author: Vadivel Mohanakrishnan 31 Oct 2006 | Member Level: Diamond | Rating:  Points: 2 |
ALTER TABLE always adds new columns at the end of the table and WILL NOT LET YOU add new columns AT A SPECIFIC POSITION.
Work Around: Make use of SQL Server Enterprise Manager.
Inside Enterprise Mgr go to the design view of the table (ie., choose a table and right click and say 'Design Table'). Now you can right click on a location / position of ur choice and select 'Insert Column'.
FYI, Enterprise Mgr drops and recreates the table to add a column at a specific location. So there might be a delay in that process.
Hope this helps!
Best Regards
Vadivel
MVP SQL Server
http://vadivel.blogspot.com
|
| Author: Rajaraman 31 Oct 2006 | Member Level: Diamond | Rating: Points: 2 |
you cant' it from alter command, so use enterprise mgr to solve it..
|