Subject Re: [firebird-support] Firebird : find strign in all database
Author liviuslivius
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
Karol Bieniaszewski
W dniu 2017-01-10 18:19:34 użytkownik startx252000@... [firebird-support] <> 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