/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 vote342 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
2 votes328 views1 answer
How to get weekday from old date in sql
SQL
0 vote343 views2 answers
Starts and end with vowel sql
SQL
0 vote382 views3 answers
Characters found after end of sql statement
SQL
0 vote323 views1 answer
Replace \n sql
SQL
0 vote355 views1 answer
Renommer base sql
SQL
0 vote379 views1 answer
Oracle winter time change
SQL
11 votes368 views2 answers
Having clause in sql
SQL
3 votes361 views2 answers
How to force truncate a table in mysql
SQL
0 vote393 views3 answers
Postgres trim string
SQL