Subject Re: [firebird-support] Re: How to set field descriptions
Author unordained
---------- Original Message -----------
From: "sqlsvr" <sqlsvr@...>
> Having worked with large business processes, the "data dictionary" the
> SQL standard defines is a joke.
> The information_schema or any proprietary "db catalog" does not store
> metadata about an attribute regarding domain, context, roles,
> dependencies etc. That is why it is just best to use a data modeling
> tool like Visio combined with a spreadsheet.
------- End of Original Message -------

"any proprietary db catalog" is overly broad. Consider that rdb$dependencies does
track per-field dependencies, among other things. "Domain" has many definitions,
but if you use Firebird domains the way they're intended (with the ability to
include custom check constraints), you can probably get pretty close to what I
think you mean. The rest would require further elaboration to answer.