/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 vote94 views1 answer
How to connect sql server using ip address in c#
SQL
7 votes170 views3 answers
Restore postgres database from sql file
SQL
0 vote154 views1 answer
Difference between db.query and db.execute
SQL
2 votes134 views2 answers
Join update query in sql
SQL
-1 vote138 views1 answer
How to check table exists or not in postgresql
SQL
12 votes170 views6 answers
Distinct in sql server
SQL
0 vote150 views1 answer
How to get nth number in sql
SQL
0 vote156 views2 answers
Transaction php
SQL
16 votes149 views1 answer
Mssql int max value
SQL
0 vote136 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL