distal-attribute
distal-attribute
distal-attribute
distal-attribute

View columns in table tree?

User, date Message
Written by microUgly
3 years ago
Category: General
20 posts since Fri, 16 Apr 10
Is it possible to have the columns for a table listed in the tree of tables?

This is something MySQL Workbench and SQLyog does and is handy when you're working on a table or trigger and need to quickly see the column for a table.

OR perhaps theirs a good alternative? Currently I run a second instance so I can view the table structures as I'm writing a trigger. But it becomes awkward to switch between the two windows.
Written by ansgar
3 years ago
5045 posts since Fri, 07 Apr 06
Columns are also listed on each "Query" tab, in the right tree box, when a table is selected.
Written by microUgly
3 years ago
20 posts since Fri, 16 Apr 10
The catch with that is that selecting a table will abort my trigger editing. So I can't view the columns for a table whilst editing a trigger at the same time.

I can switch to the query tab and run SHOW columns for the table I'm interested it, but it's not very convenient.
Written by ansgar
3 years ago
5045 posts since Fri, 07 Apr 06
Yes, very right I guess. I thought you were working in a query tab.

In that case please note that in the trigger body, typing "new." or "old." will pop up the columns of the trigger-mapped table. Probably that helps?
Written by microUgly
3 years ago
20 posts since Fri, 16 Apr 10
Not so much in my case--just because the triggers are used to check values in other tables to ensure the operation is allowed before proceeding. But it's good to know and I appreciate you taking the time to respond.
Written by ansgar
3 years ago
5045 posts since Fri, 07 Apr 06
What I just notice, also this works for other tables: Typing the table name and a dot - "sometable.".
 

Please login to leave a reply, or register at first.