[firebird-support] Firebird:Search All Fields In All Tables For A Specific Value
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
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