Subject Re: [firebird-support] Constraint
Author Fidel Viegas
On Feb 19, 2008 6:56 PM, Sergio <sergiog@...> wrote:

> Hi. FB 1.5.3 SS. I want to create a constraint to relate some own table with
> a system table containing server/database users.
>
> ALTER TABLE
> SomeTable
> ADD CONSTRAINT
> FK_SomeTable_Users
> FOREIGN KEY(User_id)
> REFERENCES "some system table"(User_id)
> ON DELETE CASCADE
> ON UPDATE CASCADE;
>
> It's that possible?

Hum.... missed this question. No, it is not possible. The user
information is stored in another database called security.fdb

Fidel.