/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 vote287 views1 answer
Dbms_output sql developer
SQL
2 votes308 views2 answers
Sql lag
SQL
0 vote305 views1 answer
Datatables server side filter where clause
SQL
1 vote284 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote308 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
3 votes278 views1 answer
Oracle apex warn on unsaved changes
SQL
0 vote273 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote281 views1 answer
Date on SQL
SQL
6 votes271 views2 answers
Mysql check auto increment value
SQL
1 vote260 views1 answer
Sql only five first row
SQL