Must be possible to filter table names in a single database?

Mysql Workbench

Mysql Workbench Problem Overview


As far as I can tell, the search filter in the navigator will only search available database names, not table names.

If you click on a table name and start typing, it appears that a simple search can be performed beginning with the first letter of the tables.

I'm looking for way to be able to search all table names in a selected database. Sometimes there can be a lot of tables to sort through. It seems like a feature that would likely be there and I can't find it.

Mysql Workbench Solutions


Solution 1 - Mysql Workbench

Found out the answer...

If you type for example *.test_table or the schema name instead of the asterisk it will filter them. The key is that the schema/database must be specified in the search query. The asterisk notation works with the table names as well. For example *.*test* will filter any table in any schema with test anywhere in the table name.

Solution 2 - Mysql Workbench

You can use the command

SHOW TABLES like '%%';

To have it always in your tools, you can add it as a snippet to SQL aditions panel on the right. Then you can always either bring it in your editor and type your search key between %%, or just execute it as it is (It will fetch all the tables of the database) and then just filter using the "filter rows" input of the result set.

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestiongroovenectarView Question on Stackoverflow
Solution 1 - Mysql WorkbenchgroovenectarView Answer on Stackoverflow
Solution 2 - Mysql WorkbenchGeorgeView Answer on Stackoverflow