/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

0 vote137 views1 answer
List mysql tables and views
SQL
4 votes185 views1 answer
Mysql delete last row
SQL
1 vote163 views2 answers
Sql select only row with the max date
SQL
2 votes160 views2 answers
Mysql on duplicate key update get value from values
SQL
4 votes148 views1 answer
Wilayah indonesia database
SQL
1 vote179 views1 answer
Continue in sql
SQL
0 vote144 views1 answer
How to select only a certain date sql
SQL
0 vote159 views1 answer
Mysql multiple group by
SQL
1 vote135 views1 answer
Oracle sql create view
SQL
0 vote139 views1 answer
Oracle last character of string
SQL