sqlmetadatafirebirdsystem-tables

How to get the name of the domain that is assigned to a specific field/column of a table?

I use a select from StackOverflow: How can I get the table description (fields and types) from Firebird with dbExpress to get schema-data of Firebird databases.

However, this select does not show the name of the domain that is assigned to a field/column.

Does anybody know the syntax to get the domain-name, too?

Solution

  • The column RDB$FIELD_SOURCE in the table RDB$RELATION_FIELDS hold the the field domain name. (@Marcodor)

    Syntax: RF.RDB$FIELD_SOURCE AS FIELD_DOMAIN,