There isn't any wrong sql statement.
I have seen this problem some times.

Backup the database with gbak or Ibcolsole.
Restore the database.
After that execute sql statement.
It will success probably.




Ibrahim Bulut
Software Developer
Republic of Turkey

----- Original Message -----
From: "Benny Setiawan Tanua" <btanua@...>
To: <ib-support@yahoogroups.com>
Sent: Thursday, May 23, 2002 9:14 AM
Subject: [ib-support] unsucessful metadata


> Dear All,
>
> i have problem
> i use this query :
> CREATE TABLE M_ROLES(ROLE_ID INTEGER NOT NULL PRIMARY KEY,
> STATUS INTEGER,
> NAME VARCHAR(64),
> CREATED DATE,
> CLOSED DATE,
> NOTE VARCHAR(128),
> PARENT_ROLE_ID INTEGER ,
> FOREIGN KEY (PARENT_ROLE_ID) REFERENCES
> M_ROLES(ROLE_ID)
> );
>
> but error :
> unsucessful metadata object M_ROLES is in use
>
> does anyone knows about this error and why..??
>
> Thanks,
> -bst-
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>