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
Re: [firebird-support] Firebird : find strign in all database
liviuslivius liviusliv...@poczta.onet.pl [firebird-support] Wed, 11 Jan 2017 00:38:24 -0800
- [firebird-supp... startx252...@yahoo.fr [firebird-support]
- Re: [SPAM... 'Neville Richards' nevi...@meltonisl.com [firebird-support]
- Re: [fire... liviuslivius liviusliv...@poczta.onet.pl [firebird-support]