HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMajor

Why isn't INFORMATION_SCHEMA displayed in the MySQL Workbench UI by default?

Submitted by: @import:stackexchange-dba··
0
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?

Solution

Click on

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.