Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

How Do I Reorder The Fields Of A Table?

Avatar of alphonsobasemore
alphonsobasemore asked on
Microsoft Access
13 Comments1 Solution666 ViewsLast Modified:
Hello Everyone,

      I want to insert a field into a table and then I want to change the order of the field I inserted and another field. Technically all I want to do is reorder just two fields, because the field at the end of the table is just a primary key or identifier for each record; all the other fields are important and the order does matter.  Therefore, I want the fields I add to be inserted before the last field or column in each table.  I've looked over several postings related to this issue and I've found that most of the postings mentioned that this isn't possible, but one posting did mention that you could change the coding of the ALTER command like so:

ALTER TABLE the_table
CHANGE COLUMN email email VARCHAR(255) AFTER id;

, which was posted by VoteyDisciple in this posting: https://www.experts-exchange.com/Databases/Mysql/Q_22074916.html

I was wondering if this posting is considered correct, a mistake or does this code refer to another sql engine other than MS Access, because I can't seem to get the code to work on my database and I just wanted to know if this code could be altered to accomplish what I desire or if there existed another technique to accomplish what I want.

Avatar of rockiroads
This problem has been solved!
Unlock 1 Answer and 13 Comments.
See Answers