Solved

ALTER TABLE: insert a field and specify location of new field

Posted on 2004-10-08
2
289 Views
Last Modified: 2011-04-14
I have an existing table with several fields.  I want to alter the table to insert a new field in a specific location, say, after the third existing field.  Is there a way to specify on the add where the new field is put?  Thanks.
0
Comment
Question by:rsoble
2 Comments
 
LVL 6

Accepted Solution

by:
boblah earned 250 total points
ID: 12260074
Hi rsoble,

no, unless you drop the whole table and recreate

Cheers!
0
 
LVL 1

Author Comment

by:rsoble
ID: 12260117
Thank you for the fast answer!
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now