/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

1 vote217 views1 answer
Pentaho + pasar de excel a sql
SQL
3 votes202 views1 answer
Index using in query plsql
SQL
0 vote231 views1 answer
Sql server get date of previous sunday
SQL
7 votes203 views2 answers
Create index mysql
SQL
5 votes215 views1 answer
Oracle scan source ddl
SQL
1 vote284 views2 answers
Copy table in sql
SQL
0 vote226 views1 answer
Mysql where in maintain order
SQL
1 vote214 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
0 vote208 views1 answer
Sql developer format sql
SQL
2 votes183 views1 answer
Foreign key example in dbms
SQL