Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Is there some Data Dictionary tool or feature in Firebird?

April 26, 2017Data dictionary feature Firebird Tool

0

10 Posted

Is there some Data Dictionary tool or feature in Firebird?

1 Answer

0

10 Posted

Yes, there is. All database objects are stored in system tables (names starting with RDB$) and almost all of those tables have RDB$DESCRIPTION field, which is a textual BLOB field, so you can put unlimited amount of text there. Most GUI administration tools give you a way to easily edit those description fields (for example, each properties page in FlameRobin shows those descriptions by default). There is also a specialized freeware tool called IBDesc that is also able to print nice reports about entire database: tables with fields and descriptions.