patternsqlMajor
Why isn't INFORMATION_SCHEMA displayed in the MySQL Workbench UI by default?
Viewed 0 times
whytheworkbenchdisplayedinformation_schemamysqldefaultisn
Problem
I am running MySQL Workbench 6.3 CE. The following is the default look of the UI:
I can query the INFORMATION_SCHEMA database, but it is not shown by default under the SCHEMAS section in the navigator panel on the left. Why is this, and how can I get this database to show up on the said panel?
I can query the INFORMATION_SCHEMA database, but it is not shown by default under the SCHEMAS section in the navigator panel on the left. Why is this, and how can I get this database to show up on the said panel?
Solution
Click on
Click on Refresh icon on the right side of Schemas in the left side bar.
I am using 6.3CE. Older versions may have something similar.
Edit -> Preferences -> SQL Editor and then check the box "Show Metadata and Internal Schemas"Click on Refresh icon on the right side of Schemas in the left side bar.
I am using 6.3CE. Older versions may have something similar.
Code Snippets
Edit -> Preferences -> SQL Editor and then check the box "Show Metadata and Internal Schemas"Context
StackExchange Database Administrators Q#177796, answer score: 26
Revisions (0)
No revisions yet.