Subject | Re: [SPAM] [firebird-support] Firebird : find strign in all database |
---|---|
Author | Neville Richards |
Post date | 2017-01-11T09:02:40Z |
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.
Neville Richards
Sent: Tuesday, January 10, 2017 5:19 PM
Subject: [SPAM] [firebird-support] Firebird : find strign in all
database
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