Playing with Firebird System Tables

find_primary_key.sql

-- [en] select primary key field of all tables
-- [pt] selecionar o campo primary key das tabelas

select
    i.rdb$index_name,
    s.rdb$field_name
from
    rdb$indices i
left join rdb$index_segments s on i.rdb$index_name = s.rdb$index_name
left join rdb$relation_constraints rc on rc.rdb$index_name = i.rdb$index_name
where
    rc.rdb$constraint_type = 'PRIMARY KEY'

select_all_tables.sql

-- [en] select all tables
-- [pt] selecionar todas as tabelas

select distinct
    rdb$relation_name
from
    rdb$relation_fields
where
    rdb$system_flag = 0
and
    rdb$view_context is null;

select_all_tables_views.sql

-- [en] select all tables and views
-- [pt] selecionar todas as tabelas e views

select distinct
    rdb$relation_name
from
    rdb$relation_fields
where
    rdb$system_flag = 0;

select_all_views.sql

-- [en] select all views
-- [pt] selecionar todas as views

select distinct
    rdb$view_name
from
    rdb$view_relations;

select_object_types.sql

select
    rdb$type,
    rdb$type_name
from
    rdb$types
where
    rdb$field_name = 'rdb$object_type'