Subject | Re: [firebird-support] Constraint |
---|---|
Author | Fidel Viegas |
Post date | 2008-02-20T09:24:50Z |
On Feb 19, 2008 6:56 PM, Sergio <sergiog@...> wrote:
information is stored in another database called security.fdb
Fidel.
> Hi. FB 1.5.3 SS. I want to create a constraint to relate some own table withHum.... missed this question. No, it is not possible. The user
> 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?
information is stored in another database called security.fdb
Fidel.