Skip to content

Instantly share code, notes, and snippets.

@tkovs

tkovs/search_field.sql

Created October 19, 2017 12:26
Show Gist options
  • Save tkovs/5400c56c21affe67b0edd8086da8a25c to your computer and use it in GitHub Desktop.
Save tkovs/5400c56c21affe67b0edd8086da8a25c to your computer and use it in GitHub Desktop.
Download ZIP
Search a FIELD in a database
Raw
search_field.sql
SELECT f.rdb$relation_name, f.rdb$field_name
FROM rdb$relation_fields f
JOIN rdb$relations r ON f.rdb$relation_name = r.rdb$relation_name
AND r.rdb$view_blr IS null
WHERE f.rdb$field_name LIKE '%FIELD%'
ORDER BY 1, f.rdb$field_position;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment