--- In firebird-support@yahoogroups.com, "wgonzaless" <wgonzaless@...>
wrote:

>
> Hello all.
> I dropped a foreing key (accidentally) and I want to restore it, but
> it is not possible, the error message is:
>
> "This operation is not defined for system tables.
> unsuccessful metadata update.
> object PROPS_ATTS_LINKS is in use ."
>
> PROPS_ATTS_LINKS is the referenced table. It seems that the FK was

not

> deleted from metadata.
> How can I restore the FK?
>
> Thank in advance,
> William GS
>

Hello again.
This problem is not only for a deleted FK, it happens whenever I want
to add a FK to an existent table. The message is the same:

"This operation is not defined for system tables.
unsuccessful metadata update.
object REFERENCED_TABLE is in use"


What could be the problem?
Thanks in advance,
William GS