Subject Re: [firebird-support] Foreign keys
Author Milan Babuskov
Geert Bevin wrote:
> I'm trying to create foreign keys during the definition of a table, for
> instance like this:
> create table car (id INT NOT NULL PRIMARY KEY, name varchar(10));


> create table person (id INT NOT NULL PRIMARY KEY, carid INTEGER,
> FOREIGN KEY (carid) REFERENCES car (id));
> I get the following error message if I'm not the only one connected to
> the database:
> Statement failed, SQLCODE = -607
> unsuccessful metadata update
> -object CAR is in use


Milan Babuskov