/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

5 votes119 views1 answer
Oracle get nls settings
SQL
1 vote135 views1 answer
Convert epoch to date in sql server
SQL
0 vote126 views1 answer
Java sql timestamp now
SQL
0 vote82 views1 answer
Microsoft sql server management studio clear cache
SQL
0 vote134 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
0 vote233 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
19 votes158 views6 answers
Create table sqlite
SQL
3 votes141 views1 answer
Oracle revoke
SQL
3 votes134 views1 answer
Postgres select max value
SQL
0 vote189 views1 answer
Oracle sql all days except weekends
SQL