Subject Re: [firebird-support] Firebird : find strign in all database
Author liviuslivius
Post date 2017-01-11T08:37:36Z
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 startx252000@... [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