I think you would probably have to provide some external programming to solve this. I can't see a way of putting a SQL solution together.
Using external programming (any of the usual development systems) you can get a list of tables, together with a list of fields they contain, and the data types they have. You can then programmatically construct SQL (for each table) something like: select * from <this table> where <field1>||<field2>|| etc like ‘%<the string required>%’ It might take a long time though. Neville Richards From: mailto:firebird-support@yahoogroups.com Sent: Tuesday, January 10, 2017 5:19 PM To: firebird-support@yahoogroups.com Subject: [SPAM] [firebird-support] Firebird : find strign in all database Hi all, I am looking for a procedure or a function to find a stirng in my database I have a DB with 200 tables and want to find a specific string (record) in a my DB I don't know the name of table / field. Thanks for any help
