CODEWITHSUNDEEP
mysql-workbench
groovenectar
groovenectar

Reputation: 2928

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

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.

Upvotes: 66

Views: 15981

Answers (2)

groovenectar
groovenectar

Reputation: 2928

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.

Upvotes: 155

George
George

Reputation: 311

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.

Upvotes: 0

Related Questions