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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Inserting new column between two columns

Author  Topic 

Ish
Starting Member

11 Posts

Posted - 2011-09-15 : 06:59:07
Hi
I am new to creating database and tables.
I am using Microsoft SQL Server Express 2008.
I am using Microsoft SQL Server Management Studio GUI interface for design and building work.
I would like to create new column between two columns.
When I try to insert this column, I get message, i need to drop the table and recreate.
Is there any way of inserting new column in between two columns

Please can someone help.

Many thanks

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-09-15 : 07:11:17
The order of the columns is irrelevant to the database engine. The only way of acomplishing this is to drop and recreate the table. There is a setting in Management Studio which is preventing you to do such changes...if you go in to preferences of SQL Server Management Studio you will find it. Unfortunately I can't remember exactly where it is...

- Lumbago
My blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2011-09-15 : 08:06:01
Tools : Options : Designers : Tables and database designers : "Prevent saving tables that require Drop and re-creation"

UN-check that option
Go to Top of Page
   

- Advertisement -