|Subject||RE: [IBO] Viewing source for computed column with IB_SQL?|
> I have a table with a computed column. If I connect to the databaseI don't know the IB_SQL way (perhaps it isn't supported), but you
> with IB_SWL, then browse the database, and look at the source for the
> table, I see the following for that field:
> , PRODAVGCOST DOUBLE PRECISION /* Computed */
> Why is there only a comment about it being computed? Where is the
> "computed by" clause? How can I see that?
can query the RDB$FIELDS system table yourself, if you like ;-).
from rdb$fields f join rdb$relation_fields rf on (f.rdb$field_name=rf.rdb$field_source)
where f.rdb$computed_blr is not null;
The IB LogManager Product Family
Logging/auditing suite for InterBase/Firebird