When one uses "ALTER TABLE tab ADD col", the brand new column will get put into the finish on the table. For instance:
TABLE: TAB COL_1 COL_2 COL_4 ALTER TABLE TAB ADD COL_3
table will end up
TABLE: TAB COL_1 COL_2 COL_4 COL_3
However because the naming of my example posts indicates I'd really such as the table to finish up such as this:
TABLE: TAB COL_1 COL_2 COL_3 COL_4
With COL_3 before COL_4.
Besides repairing the table on your own, can there be any standard SQL which will complete the job? If however there's no standard SQL, I possibly could still apply certain vendor dependent solutions for Oracle, however a typical solution might be best.
Automatically, posts are just added in the finish.
To place a column in the centre, you need to drop and recreate the table and all sorts of related objects (constraints, indices, defaults, associations, etc).
Several tools do that for you personally, and with respect to the size on the table, this might be a rigorous operation.
You may even consider creating sights up for grabs that display posts within the order of preferrence (overriding the particular order within the table).
http://www.orafaq.com/wiki/SQL_FAQ#How_does_one_add_a_column_to_the_middle_of_a_table.3F states it cannot be achieved, and indicates workarounds of renaming the table and carrying out a
create table as select... or (something I'm not really acquainted with) "Make use of the DBMS_REDEFINITION package to alter the dwellingInch.
ALTER TABLE TABLENAME ALTER COLUMN COLUMNNAME POSITION X