/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 vote172 views1 answer
Sql drop default
SQL
-2 votes218 views3 answers
How to fetch first 10 rows in sql
SQL
0 vote165 views1 answer
Stored function in sql
SQL
4 votes159 views4 answers
Start mysql
SQL
5 votes150 views1 answer
Mysql add user with all privileges
SQL
0 vote163 views1 answer
On sql table data exists
SQL
2 votes161 views2 answers
Mysql count rows returned
SQL
1 vote161 views2 answers
Sql left characters
SQL
-1 vote160 views1 answer
How to create foreign key in sql server management studio
SQL
0 vote333 views1 answer
Get first match in each group mysql query
SQL