How to search for database tables that has column names matching certain values?

In IntelliJ’s Database Tool, is there a way to search for database tables that has column names that contains certain values? For example, find tables that has column name that contains foo.

4 comments
Comment actions Permalink

Sure. You can search for columns matching *foo* via Go-to-Symbol (Ctrl-Alt-Shift-N) action.

0
Comment actions Permalink

Can I find a specific column in a table view, like when you open a table and it has many columns and you just want to find a column by typing its name instead of scrolling left and right? 

0
Comment actions Permalink

Sure. One can use Structure Popup (Ctrl-F12 or Cmd-F12 on macOS) for navigation and searching as in any other editor.

One can also use Structure tool window for that, but it'll take some screen space.

1
Comment actions Permalink

Awesome! Thanks.

0

Please sign in to leave a comment.