Subject Re: [Firebird-Architect] Feature Request: Domains in SP & Triggers.
Author Martijn Tonies
> key on system tables is the source. You can, of course, declare
> a foreign key on any field in the parent table that has a
> unique index.

No you can't.

It needs a unique/primary constraint.

> > Can't create FK to system table. Not sure
> >about triggers... If I create triggers for system table will they
> >survive during backup/restore?
> Not at the moment, if my memory serves which it often does not, but
> that can be fixed.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions