/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

13 votes173 views3 answers
Mysqldump structure only
SQL
0 vote147 views1 answer
How to combine rows in sql server procedure
SQL
0 vote174 views1 answer
Parent and child link in mysql
SQL
5 votes125 views1 answer
Find table from column name in sql
SQL
1 vote145 views2 answers
Full join
SQL
0 vote125 views1 answer
Php mysqli install
SQL
0 vote143 views1 answer
How to insert same table data using mysql query
SQL
-1 vote129 views1 answer
Auto increment psql not primary key
SQL
0 vote121 views1 answer
Heavy table in mysql
SQL
27 votes138 views6 answers
Sql update record
SQL