Hi,
I have installed Firebird a week ago. I am trying to do some tests with
tables and constraints.
When I try to run the script below the last alter table give me this error:

Resource Exception. unsuccessful metadata update
object T1 is in use
Reason: unsuccessful metadata update
object T1 is in use

Can someone help me?

Thanks

Vito Chiarello

P.S the script

create table t1(
id_t1 integer not null,
name_t1 varchar(50))

create table t2(
id_t2 integer not null,
id_t2_t1 integer not null,
name_t2 varchar(50))

alter table t1 add constraint t1_pk primary key (id_t1)

alter table t2 add constraint t2_pk primary key (id_t2)

alter table t2 add constraint t2_t1_fk foreign key (id_t2_t1) references
t1(id_t1)


[Non-text portions of this message have been removed]