Assume opened a database table and went to the "Data" Tab with approx 20 table columns.First question: When I double click on a table in Object explorer Toad jumps always at first to the "Column" tab.How can I tell Toad to open by default at first the "Data" tab?Ok, Now in the "Data" tab I changed some columns visually (I moved e.g. column from pos 15 to the leftmost column).After disconnect, exit,reconnect, and reopening of the "Data" tab the 15th column is again the 15th column in the "Data" view.Toad does not remember my previous visual column rearrangments.Is there a way to fix these re-orderings of columns permanently?Thank youPeter
You can rearrange the tabs of the right hand side by going into the options and going into the explorer|objects page.Unfortunately we don't preserve the layout of each individual data tab table.
Ok, thank you.But could you include such a feature in the next release?Is there a official feature application request form?Peter
This will probably not be added because there are a couple of problems with having it.1. It would have to be saved per table which means it would actually start taking up a lot of space in the case of people with a lot of connections and tables. Worse we will not be able to detect when they are no longer needed in case you move to other servers etc so they would pile up.2. If the layout of the tables changed (Let's say you add a column) we would still restore the old layout and you wouldn't see the new column until you actually added it in from the column chooser (A feature I doubt most people even know exists).
Couldn't you just edit the column positions in the table itself, assuming you have rights to do so?It shouldn't affect any existing apps unless one is somehow hard-coded to look-up by column order.
Well, you can do that already but you need to do it using the alter table dialog.Just keep in mind that this can be an expensive operation since it requires the entire table to be reconstructed because the column order decides how the data is stored in the drive. Doing this just because someone moves a column in a grid is just not going to happen.
I know that the columns can be physically re-arranged by an "Alter tabel" command.But could Toad built this difficult ALTER TABLE command automatically from my visual drag&drop moves?Assume I moved two columns to other positions. I want to click now a Toad "restructure" menu and Toad should ALTER TABLE the whole table correspondingly.Could you implement this?@MauritzIn reply to your two considerations of 26 Sep let me suggest the following behaviour:ad 1.: The new layout needs only to be saved when the user want a re-arrangement.Otherwise nothing needs to be stroed.I need a re-aarangement only rarely for certain tables.ad 2.) If the layout of a TABLE changes (which is in reality rare as well) the former layout is obsolet and can be removed immediately.So Taod only needs to check whether all columns in layout exist in current table as well.Thats all. Easy to implement.Given this would you mind to consider this feature?Thank youPeter
Just once more again:If I re-arrange the columns visually in Toad I would appreciate to have a menu/icon which correspondingly re-arranges the columns physically in database (by an ALTER TABLE command).Yes, I know it could be time consuming. But thats the decision of the user.Can this be implemented in the next release?Thank youPeter