CODEWITHSUNDEEP
sqlmetadatafirebirdsystem-tables
Bastian Blanc
Bastian Blanc

Reputation: 41

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?

Upvotes: 1

Views: 279

Answers (1)

Bastian Blanc
Bastian Blanc

Reputation: 41

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,

Upvotes: 1

Related Questions