| Subject | Re: [firebird-support] Firebird:Search All Fields In All Tables For A Specific Value |
|---|---|
| Author | Robert martin |
| Post date | 2018-02-11T22:49:37Z |
On 12/02/2018 10:03 AM, ioripalm@... [firebird-support] wrote:
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.
Cheers
Rob
>Hi
> 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.
Cheers
Rob