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

[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 RDB$RELATION_FIELDS 
 WHERE RDB$RELATION_FIELDS.rdb$relation_name = 'Each Tables Name'

 

 I make a Script program It running very slowly.
 

 Witch way will be quickly?
 Thank you !