How to insert a column in middle order?

Hi,i have 1 table contain 2 column if i add a new column it default stored in last column but my recruitment adding the new column in middle of the order so can any one explain

Questions by thoufik

Showing Answers 1 - 24 of 24 Answers

ajay

  • Dec 6th, 2011
 

We can do it by using the ORDER BY clause.

  Was this answer useful?  Yes

Chandu

  • Dec 6th, 2011
 

You can use BEFORE < col name >
or
AFTER < col name >
or
< col name > 2

Here 2 is the position that the new col is about to place.

  Was this answer useful?  Yes

preethi

  • Dec 7th, 2011
 

Mr. Chandu can you give some example code. I am not clear with the code you have posted.

  Was this answer useful?  Yes

sivaprasad

  • Apr 1st, 2015
 

Using fly on table table1.col1,table2.col1,
table1.col2 from table1,table2

  Was this answer useful?  Yes

suraj

  • Apr 6th, 2015
 

You cannot insert in middle.By default it will insert at last column only.

  Was this answer useful?  Yes

Sunita

  • Jun 12th, 2015
 

You cannot really change the column order/id. if possible, drop the table and recreate it with columns in the right order. but what is the need?

  Was this answer useful?  Yes

Shailendra

  • Jun 16th, 2015
 

Open design view and select place where you want to insert new columns.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions