1

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?

Mark Rotteveel
  • 100,966
  • 191
  • 140
  • 197
Bastian Blanc
  • 41
  • 4
  • The column RDB$FIELD_SOURCE in the table RDB$RELATION_FIELDS hold the the field domain name. – Marcodor Feb 11 '22 at 11:38
  • See the official documentation about the System Tables: https://www.firebirdsql.org/file/documentation/chunk/en/refdocs/fblangref30/fblangref30-appx04-systables.html – Arioch 'The Feb 11 '22 at 12:10

1 Answers1

1

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,

Bastian Blanc
  • 41
  • 4