Wednesday 15 January 2014

database - Oracle move column to the first position -


Is there any way to move the columns in place from the final position to the first place? Someone has left the ID column, and has rebuilt it. So now it's finally, this is a problem because some of our PHP scripts are using the first column as identifier (a basic model, more than 100 other models using this base object).

See also

says:

Oracle allows only the column to be added at the end of an existing table.

You want to recreate your table.

  Rename tab 1_all to tab 1; Select ID as the Select Tab, & lt; Your left column & gt; Tab 1_old;  

No comments:

Post a Comment