Table structure view enhancement

[Lukasz Indeka]

Could it be possible to add sorting possibility on the Columns tab of the table structure window? Reasoning: when I have a very wide table (with many columns) it's often hard to find specific column. I have to

select * from selected_table

then switch to the Single Record View and set proper order currently.

 

[Marco Kalter]

I have added this to the list of enhancement requests.

Note that you can also use the "Filter columns" button on the result set toolbar to quickly find specific columns.

 

[Lukasz Indeka]

Thanks! I haven't used this option yet.

 

[Lukasz Indeka]

One more request for the same window. Could it be possible to add a deferred data retrieval option? What I mean: when I have very wide table, then the opening of the window is very slow (especially for remote connection). I would prefer to have this window opened after 1 second on the General tab and then have to wait another second when I change the tab to Triggers than have to wait 4 seconds before the window is opened at all (with full data on place).

 

[Marco Kalter]

I have added this to the list of enhancement requests as well.

 

[Lukasz Indeka]

I'm still thinking about this and having more ideas. Please add sorting also on the rest of tabs and columns of the grids (except General tab, of course). And, possibly, filtering by all the Name columns and additionally:

• Columns on the Keys tab,
• Columns on the Indexes tab,
• Grantee and References on the Privileges tab.

Ideally, the filtering feature would work as you type (quick search), not after pressing some form button or Enter key.

 

[Marco Kalter]

Noted as well.