Subject Re: [SPAM] [firebird-support] Firebird : find strign in all database
Author Neville Richards
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
 
Sent: Tuesday, January 10, 2017 5:19 PM
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