> 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
Server.
Upscene Productions
http://www.upscene.com