How do I remove collations and schemas from Database tool window?

I recently upgraded to phpStorm 2017.3 and found that the database tool window now shows collations and schemas. In my earlier version, it'd directly show 'local' database and all the tables I have.

 

Is there a way to show it like this (taken from https://confluence.jetbrains.com/display/PhpStorm/Databases+and+SQL+Editor+in+PhpStorm)

7 comments

It's possible, you need to click on Gear icon and uncheck Group Schema option

But the problem for me that even in that case all collations will be displayed next to database:

Does it possible to hide all these collations from navigation view?

0

Have already tried that, @Michael. Just want to get back to the original view where I only see the database name and tables. 

4

Not possible yet. We've notified corresponding developers - they'll try to address in timely fashion.

 

1

https://youtrack.jetbrains.com/issue/DBE-5557 link to corresponding request, it's still not addressed yet, unfortunately.

1

The Object Filter would be a perfect place to make this happen. Text there:

A <pattern> or a list of <type>:[-]<pattern> separated by ||. Where:
<type> is a table, view, mview, sequence, routine, package or synonym,
<pattern> is a regular expression; prepend with - (minus) for exclusion.
Examples: table:CUR_.* or table:-OLD_.*||routine:DO.*||view:V_.*

If for <type> we could use `collation` we could have `collation:-*` or something.

 

3

Thanks a lot.

Filtering works perfectly.

0

I don't know if this was possible before but im using

PhpStorm 2018.2 - Build #PS-182.3684.42, built on July 26, 2018

There you can click on Filter and deselect Collection

After deselecting Collection, there is no need to uncheck Group Schema. Obviously there is nothing happen anymore anyways. So actually it doesn't matter if it's checked or not :)

2

Please sign in to leave a comment.