/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 vote123 views1 answer
How to display value of variable in mysql
SQL
-1 vote69 views2 answers
On delete set default sql server
SQL
18 votes133 views3 answers
Get the list of all tables in sql server
SQL
0 vote109 views1 answer
Sql check for null and empty string
SQL
0 vote151 views1 answer
Tsql cte in a transaction
SQL
0 vote118 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
0 vote120 views1 answer
Postgresql if else endif
SQL
1 vote124 views2 answers
Sql server concat string and int
SQL
0 vote129 views1 answer
Show table structure mysql console
SQL
6 votes125 views1 answer
Oracle rank
SQL