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 |
Ish
Starting Member
11 Posts |
Posted - 2011-09-15 : 06:59:07
|
HiI 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 columnsPlease 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...- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
|
|
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 |
|
|
|
|
|