Subject Re: [firebird-support] find a string records in all my tables
Author Mark Rotteveel
On 10-1-2017 18:10, startx252000@... [firebird-support] wrote:
> 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.

There are no ready-made solutions for this. You will need to write a
script that identifies all tables and constructs a query for each table
to check all char, varchar and blob sub_type text columns.

Mark
--
Mark Rotteveel