I'd like to have the possibility to add column at a given offset.
Currently it's possible to add column at the end of a table. When working with big tables, If someone wants to add a column in a specific position the task becomes really uncomfortable due to the limited sintax of "add column". In fact one should create a mirror table with the entire content, drop and recreate the new table with the new columns and then copy from the mirror table the old data to the new structure. a statement like: ALTER TABLE x ADD COLUMN (desc varchar) AT 5 to add a column with column order 5 would be very nice.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.