I'd like to have the possibility to add column at a given offset.

Pietro_La_TorrePietro_La_Torre ✭
in General Discussion
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.

Comments

  • Shobhit_GargShobhit_Garg
    Hi,

    Currently we do not support such functionality to add column at any position in table.
    There is an enhancement feature request for the same, so it may come in future, but no timelines have been defined as of now.

    Thanks

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...