| Subject | Re: Firebird:Search All Fields In All Tables For A Specific Value |
|---|---|
| Author | |
| Post date | 2018-02-12T01:12:13Z |
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 !