/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

3 votes102 views2 answers
Mysql create database
SQL
0 vote108 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
17 votes113 views3 answers
Postgresql version command
SQL
21 votes120 views3 answers
Average sql
SQL
6 votes165 views2 answers
Database url postgres
SQL
0 vote109 views1 answer
How to create notes in mysql
SQL
2 votes101 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
0 vote123 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
4 votes114 views2 answers
Postgre sql create table
SQL
0 vote127 views1 answer
Provera dupliranih konatakata
SQL