/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

2 votes111 views1 answer
Oracle list duplicates
SQL
3 votes136 views5 answers
Duplicate table sql
SQL
-1 vote101 views1 answer
Extract Data from SQL Server into XML Format
SQL
1 vote104 views1 answer
T-sql find object by name
SQL
1 vote102 views1 answer
Importance of comment in mysql
SQL
9 votes126 views3 answers
Sequence postgresql
SQL
0 vote105 views1 answer
Codeigniter 3 get best-selling products
SQL
10 votes110 views2 answers
Tsql merge example
SQL
1 vote116 views2 answers
Procedure syntax
SQL
9 votes103 views4 answers
How to remove duplicate in sql
SQL