|Subject||Re: [SPAM] [firebird-support] Firebird : find strign in all database|
I think you would probably have to provide some external programming to solve this. I can't see a way of putting a SQL solution together.
Using external programming (any of the usual development systems) you can get a list of tables, together with a list of fields they contain, and the data types they have. You can then programmatically construct SQL (for each table) something like:
select * from <this table> where <field1>||<field2>|| etc like ‘%<the string required>%’
It might take a long time though.
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