Re: [firebird-support] Firebird : find strign in all database

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

Hi,
 
rather simple operation but can take very long time if database is big.
You can write stored procedure - or EXECUTE BLOCK
and inside iterate by system tables RDB$RELATIONS and RDB$RELATION_FIELDS
and do EXECUTE STATEMENT with where condition
and return back sum of fields '||' and table name where it find something 
interesting
 
regards,
Karol Bieniaszewski
 
 
W dniu 2017-01-10 18:19:34 użytkownik startx252...@yahoo.fr [firebird-support] 
<firebird-support@yahoogroups.com> napisał:
 
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