/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

2 votes331 views3 answers
Write sql query to find the second highest salary of employee
SQL
3 votes357 views2 answers
Sqlite print all column names
SQL
1 vote354 views1 answer
How to get previous year from sysdate in oracle
SQL
0 vote358 views1 answer
Incorrect string value: mysql
SQL
0 vote377 views1 answer
Mysql value ends with
SQL
0 vote381 views1 answer
Bitmap join index
SQL
1 vote366 views1 answer
Round function in sql oracle
SQL
1 vote352 views1 answer
Sql where last 12 months
SQL
3 votes327 views3 answers
Mysql get table size
SQL
1 vote364 views1 answer
Oracle enable job
SQL