Subject Re: [firebird-support] Firebird:Search All Fields In All Tables For A Specific Value
Author Robert martin
On 12/02/2018 10:03 AM, ioripalm@... [firebird-support] wrote:
> Do not know table name, do not know field name.
> Only know A Specific Value.
> How to find out witch tables and fields include this Value?
> Thank you!


Use the RDB$xxxx (firebird system) tables to first get a list of DB
tables and then a list of fields for each table.  If your value is
numeric you can just search numeric type fields.  You can do this on app
code or in a stored procedure.