I using this SQL got all tables Name:
SELECT RDB$RELATION_NAME AS TABLE_NAME
FROM RDB$RELATIONS
WHERE RDB$SYSTEM_FLAG = 0
AND RDB$VIEW_SOURCE IS NULL;
And using this to got the name of the field for each table:
SELECT RDB$RELATION_FIELDS.rdb$field_name AS NC
FROM
On 12/02/2018 10:03 AM, iorip...@sina.com [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!
>
Hi
Use the RDB$ (firebird system) tables to first get a
11.02.2018 22:03, iorip...@sina.com [firebird-support] wrote:
> How to find out witch tables and fields include this Value?
Dump whole database into text file(s) with IBexpert then grep.
--
WBR, SD.
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!
