Quickly generate queries for all non-system tables in your database in Firebird or InterBase
Posted by jpluimers on 2018/07/26
Change at will:
select 'select * from ' || r.rdb$relation_name as query from rdb$relations r where 1=1 and r.rdb$system_flag <> 1 -- no system relations and r.rdb$view_source is null -- only tables order by r.rdb$relation_name
For the EMPLOYEE demo database, this results in:
select * from COUNTRY
select * from CUSTOMER
select * from DEPARTMENT
select * from EMPLOYEE
select * from EMPLOYEE_PROJECT
select * from JOB
select * from PROJECT
select * from PROJ_DEPT_BUDGET
select * from SALARY_HISTORY
select * from SALES
–jeroen
Leave a Reply