[firebird-support] Firebird:Search All Fields In All Tables For A Specific Value

2018-02-11 Thread iorip...@sina.com [firebird-support]
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!

[firebird-support] Re: Firebird:Search All Fields In All Tables For A Specific Value

2018-02-11 Thread iorip...@sina.com [firebird-support]
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