/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

5 votes275 views1 answer
Dbms_metadata.get_ddl table
SQL
3 votes263 views2 answers
Mysql select database
SQL
6 votes239 views1 answer
Rank function in oracle with example
SQL
3 votes243 views1 answer
Sql select all
SQL
22 votes334 views1 answer
Mysql workbench
SQL
3 votes352 views1 answer
Oracle cannot access v$session
SQL
0 vote313 views1 answer
Stop and start mysql
SQL
6 votes278 views3 answers
Create database mysql utf8
SQL
0 vote254 views1 answer
Gcloud check sql
SQL
0 vote269 views1 answer
Mysql 5.6 hierarchical recursive query
SQL