Description:
The column information of a new created table is not shown until a restart of MySQL Administrator.
After creating the new table via mysql client the new table is not visible until you select another database in the catalog tree on the left and return again to database you created the table in. The newly created table is visible and all tabs show information except the column tab.
If you alter the table the new column definition won't also be visible until a restart of MySQL administrator.
How to repeat:
Open MySQL Administrator and mysql client
Select a database of your choice in the catalog tree view, say D1
Create a new table (say T1) with a couple of columns in the choosen database D1 via mysql client.
In MySQL Administrator the newly created table is not visible so select anothor database and return back to database D1
In the right view (Schemata of D1) the newly created table T1 will show up
Select table T1 and check the Column tab. This wil not show any information. Select one of the other tabs and check that there is information about the table.
Restart MySQL Administrator
Select database D1 in the Catalog tree
Select table T1 and check that the column information is visible in the view
Suggested fix:
When pointing at a table in the schemata view also read the column information and display it in the view.
Index information is updated within MySQL Administrator whenever you reselect the database in the catalog view.
Check MySQL Server for schemata changes whenever you select the table and then update the tabs with this information.
In the manual there is a reference about right clicking to refresh the schemata but this is not available in Linux MySQL Administrator.
