How to find all blob text fields in a Firebird database

Question

If I want to find the table name and column name of all columns in a Firebird database whose type is BLOB SUB_TYPE TEXT , what would be the correct metadata request to return this information?

Answer 1

Use this:

 SELECT rf.rdb$relation_name, rf.rdb$field_name FROM rdb$relation_fields rf JOIN rdb$fields f ON rf.rdb$field_source = f.rdb$field_name WHERE f.rdb$field_type = 261 AND f.rdb$field_sub_type = 1 

a list of possible rdb codes $ field_sub_type can be found here .