/SQL/Select all domains of database firbird

Select all domains of database firbird

SELECT
  f.rdb$field_name
FROM
  rdb$fields f
  LEFT JOIN rdb$relation_fields rf
    ON rf.rdb$field_source = f.rdb$field_name
WHERE
  rf.rdb$field_name IS NULL
  AND
  COALESCE(f.rdb$system_flag, 0) = 0

Source: stackoverflow.com

Similar codes

10 votes361 views4 answers
How to alter table name in mysql
SQL
1 vote341 views1 answer
Last 6 months postgresql
SQL
6 votes379 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote370 views1 answer
Mysql disable triggers
SQL
2 votes363 views1 answer
How to delete all duplicate items in mysql
SQL
11 votes359 views1 answer
Get ddl materialized view oracle
SQL
7 votes360 views1 answer
Oracle pagination query offset
SQL
1 vote360 views2 answers
Group_concat limit mysql
SQL
0 vote376 views2 answers
Replace null with 0 in sql
SQL
0 vote388 views1 answer
Check database restore status sql script
SQL