====== Lister les Tables, Vues, Champs, ... ======
===== Tables Système =====
* [[https://ib-aid.com/download/docs/firebird-language-reference-2.5/fblangref25-appx04-systables.html|Firebird 2.5 Language Reference > System Tables]]
===== Liste des Vues =====
select rdb$view_name from rdb$view_relations;
===== Liste des Tables =====
select rdb$relation_name as name, rdb$owner_name as owner, rdb$description as description
from rdb$relations
where (rdb$system_flag = 0 or rdb$system_flag is null)
and (rdb$relation_name not in (select rdb$view_name from rdb$view_relations))
order by rdb$relation_name;
===== Lister tous les champs de toutes les tables =====
select rf.rdb$relation_name, rf.rdb$field_name,
f.rdb$field_type, rdb$field_sub_type,
f.rdb$field_length, f.rdb$field_scale, f.rdb$field_precision,
f.rdb$computed_source
from rdb$relation_fields rf
left join rdb$fields f on f.rdb$field_name = rf.rdb$field_source
order by rf.rdb$relation_name, rf.rdb$field_position;