Remove entry from table name filter

ArnorBld's profile image ArnorBld posted 2 years ago in General Permalink

Hi all,

Just to clarify I'm talking about the filter in the toolbar on top, above the database/table tree. I have ended up with some table names there that are long gone and I would like to delete them from the list. But I can't see a way to do it.

If I export the settings file, I find this in an entry called "TableFilter"

TIA :)

ansgar's profile image ansgar posted 2 years ago Permalink

HeidiSQL keeps a maximum of 20 items in that table filter history. If you want to remove them, you will have to do that per regedit.exe:

  • navigate to HKEY_CURRENT_USER\SOFTWARE\HeidiSQL
  • delete value TableFilter (respectively DatabaseFilter)
ArnorBld's profile image ArnorBld posted 2 years ago Permalink

Thank you so much! It would be nice (for future reference :) to had perhaps a right click option to delete the entry. I use this quite a bit and it would be nice to be able to easily remove individual entries :)

Thanks for a fantastic product!!!

Code modification/commit ce8a401 from Ansgar Becker <anse@heidisql.com>, 2 years ago, revision 12.0.0.6532
Create context menu item "Empty recent filters" on database and table filter above tree view. See https://www.heidisql.com/forum.php?t=39447

Please login to leave a reply, or register at first.