I created a column and had to drop and add a column named ID with the identity value. Since I re-added the column ID after the creation of the table, this column was the last. I wanted to move the column in the first since it was an identity column for that table.
This is how I was able to change the order of the column ID
SSMS -> Tools----Options ---Designers --- Unheck Prevent saving changes that require table - recreation
Then change the column order in the table designer.
This blog is created to add all the information and experiences that I have learnt while working on MS sql server as a DBA. The blog is also updated frequently with the real world problem that I encounter hands on at work and the resolutions to resolve them. I hope this blog will be of some use to you and you will revisit. Thank you for stopping by and you are welcome to leave comments.
Showing posts with label alter table. Show all posts
Showing posts with label alter table. Show all posts
Tuesday, September 25, 2012
Subscribe to:
Posts (Atom)