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?

1) make sure you're the only one connected to the database

2) Foreign Keys can only be created if the table create statements are
committed.

Run the script in "auto commit" mode.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com