Como listar as tabelas do meu banco Firebird

22/09/2004

Caros amigos da lista

Um cliente me pediu para disponibilizar num formulario uma consulta, onde pudesse selecionar todas as tabelas do meu banco FIREBIRD.

Dependendo da tabela selecionada, mostraria os campos correspondentes e as opcoes de busca.

Algum amigo tem id�ia de como posso fazer?

Grato

Rbfonseca

Curtir t�pico + 0

Responder

Post mais votado

22/09/2004

para listar as tabelas::

select rdb$relation_name from rdb$relations
where rdb$system_flag = 0;

dai � s� montar as consultas com a tabela selecionada.

T+

Afarias

Responder

Gostei + 1

Mais Posts

19/07/2019

Alvaro Vieira

Creio que quando voc� escreve "todas as tabelas" n�o devem ser consideradas as do sistema, certo?
O comando correto para listar apenas as tabelas de usu�rio (sem as views por ex.) � o seguinte:

Select rdb$relation_name
from rdb$relations
where ((rdb$system_flag=0) or (rdb$system_flag is null)) and
(rdb$view_source is null)
order by rdb$relation_name

t+

Responder

Gostei + 0

22/07/2019

Emerson Nascimento

para listar as tabelas:

SELECT rdb$relation_name
FROM rdb$relations
WHERE rdb$system_flag = 0 -- somente objetos de usu�rio
    and rdb$relation_type = 0 -- somente tabelas

tipos poss�veis:
0 - tabelas
1 - views
2 - tabela externa
3 - tabela de monitoramento
4 - n�vel de conex�o GTT
5 - n�vel de transa��o GTT

para listar os campos:

SELECT r.rdb$relation_name, rf.rdb$field_name, rf.rdb$field_position
FROM rdb$relations r
INNER JOIN rdb$relation_fields rf on rf.rdb$relation_name = r.rdb$relation_name
WHERE r.rdb$system_flag = 0 and r.rdb$relation_type = 0
    AND r.rdb$relation_name = 'tabela_da_qual_deseja_listar_os_campos'
ORDER BY rf.rdb$relation_name, rf.rdb$field_position

Responder

Gostei + 0

09/10/2019

Dirceu Morais

Amigos,

Qual o comando que eu utilizo para me dar a quantidade de:

Domains
Tables
Views
Procedures
Trigger
Generations

igual aparece no IBExpert.

As Tables parece ser mais f�cil.

Responder

Gostei + 0

10/10/2019

Emerson Nascimento

Domains

select * from rdb$fields where rdb$system_flag = 0 and not (rdb$field_name like 'RDB$%') -- somente objetos de usu�rio
select count(*) total from rdb$fields where rdb$system_flag = 0 and not (rdb$field_name like 'RDB$%') -- somente objetos de usu�rio

Tables

select * from rdb$relations where rdb$system_flag = 0 and rdb$relation_type = 0 -- somente objetos de usu�rio / somente tabelas
select count(*) total from rdb$relations where rdb$system_flag = 0 and rdb$relation_type = 0 -- somente objetos de usu�rio / somente tabelas

Views

select * from rdb$relations where rdb$system_flag = 0 and rdb$relation_type = 1 -- somente objetos de usu�rio / somente views
select count(*) total from rdb$relations where rdb$system_flag = 0 and rdb$relation_type = 1 -- somente objetos de usu�rio / somente views

Procedures

select * from rdb$procedures where rdb$system_flag = 0 -- somente objetos de usu�rio
select count(*) total from rdb$procedures where rdb$system_flag = 0 -- somente objetos de usu�rio

Triggers

select * from rdb$triggers where rdb$system_flag = 0 -- somente objetos de usu�rio
select count(*) total from rdb$triggers where rdb$system_flag = 0 -- somente objetos de usu�rio

Generators

select * from rdb$generators where rdb$system_flag = 0 -- somente objetos de usu�rio
select count(*) total from rdb$generators where rdb$system_flag = 0 -- somente objetos de usu�rio

Responder

Gostei + 1

11/10/2019

Dirceu Morais

Domains

select * from rdb$fields where rdb$system_flag = 0 and not (rdb$field_name like 'RDB$%') -- somente objetos de usu�rio
select count(*) total from rdb$fields where rdb$system_flag = 0 and not (rdb$field_name like 'RDB$%') -- somente objetos de usu�rio

Tables

select * from rdb$relations where rdb$system_flag = 0 and rdb$relation_type = 0 -- somente objetos de usu�rio / somente tabelas
select count(*) total from rdb$relations where rdb$system_flag = 0 and rdb$relation_type = 0 -- somente objetos de usu�rio / somente tabelas

Views

select * from rdb$relations where rdb$system_flag = 0 and rdb$relation_type = 1 -- somente objetos de usu�rio / somente views
select count(*) total from rdb$relations where rdb$system_flag = 0 and rdb$relation_type = 1 -- somente objetos de usu�rio / somente views

Procedures

select * from rdb$procedures where rdb$system_flag = 0 -- somente objetos de usu�rio
select count(*) total from rdb$procedures where rdb$system_flag = 0 -- somente objetos de usu�rio

Triggers

select * from rdb$triggers where rdb$system_flag = 0 -- somente objetos de usu�rio
select count(*) total from rdb$triggers where rdb$system_flag = 0 -- somente objetos de usu�rio

Generators

select * from rdb$generators where rdb$system_flag = 0 -- somente objetos de usu�rio
select count(*) total from rdb$generators where rdb$system_flag = 0 -- somente objetos de usu�rio

Isso, isso, valw

Responder

Gostei + 0