/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 vote316 views2 answers
Mysql two column combination unique
SQL
19 votes285 views2 answers
Mysql add column after another
SQL
3 votes273 views2 answers
WhereIn SQL
SQL
0 vote276 views2 answers
Mysql multiply
SQL
2 votes281 views1 answer
Add 2 hours to current time in MySQL
SQL
3 votes298 views1 answer
Oracle sleep
SQL
-1 vote284 views1 answer
How to create foreign key in sql server management studio
SQL
24 votes244 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
0 vote276 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
2 votes342 views1 answer
Remove foreign key constraints in postgres
SQL