4 ms·
One of my favorite features of HeidiSQL is its "Find text in database", see https://www.heidisql.com/forum.php?t=1006 https://www.heidisql.com/forum.php?t=1006
by cholmon 8y ago
One of my favorite features of HeidiSQL is its "Find text in database", see https://www.heidisql.com/forum.php?t=1006 https://www.heidisql.com/forum.php?t=1006
It'll search through all text fields of all tables of whichever database you specify for a given string, and displays a nice per-table summary for each matching record. I haven't found anything like this in any other DB client.
- mmsimanga 8y agoSQL Workbench/J has this feature[0]. I often use this feature when someone asks me questions about a report and I don't have a clue which tables that data comes from. Just search the database. [0]https://www.sql-workbench.eu/manual/dbexplorer.html#table-search-client https://www.sql-workbench.eu/manual/dbexplorer.html#table-se...
- DKnoll 8y agoThere's an extension for SQL Server Management Studio that does it (MSSQL) as well. I don't think it's really recommended for prod DBs though.
- anjanb 8y agoI don't have to do this frequently but if any dev/QA/myself need to do this, I dump the DB and run grep. Not the fastest way for sure but gets the job done!