Interbase - listar tabelas e views |
Top Previous Next |
1) Tabelas
select rdb$relation_name from rdb$relations where rdb$view_blr is null and rdb$system_flag = 0
2) Views
select rdb$relation_name from rdb$relations where rdb$view_blr is not null and rdb$system_flag = 0
3) Tabelas do sistema
select rdb$relation_name from rdb$relations where rdb$view_blr is null and rdb$system_flag = 1 |