• SELECT colname1, colname2, colname5, colname4, colname3 into NewTableName from OldTableName

    **this will create at NewTable with columns in the above sequence.