How to create a view that lists Omains in Firebird 2.5?

Asked

Viewed 204 times

1

Does anyone know how to mount an SQL that lists "Omains" in a Firebird 2.5 database? Thanks.

firebird

1 answer

2

I apologize and hope you will take into account that I have little experience with Firebird.

The correct SQL is:

CREATE OR ALTER VIEW "Domains"( "Name" )
AS
select distinct
                        RDB$Field_Name
from
                        RDB$Fields as Fields
where
      substring (Fields.RDB$Field_Name from  1 for 4) not in ('IBE$', 'MON$', 'RDB$')
order by
                 Fields.RDB$Field_Name

However, I find it somewhat confusing that in the RDB$Fields table, the RDB$Field_name field covers both the "Fields" themselves and the "Domains".

Browser other questions tagged firebird

You are not signed in. Login or sign up in order to post.