Subject Re: [ib-support] I can not drop a Field.....
Author Paul Vinkenoog
Hi Fernando,

> Some day I made like this...:
>
> Create domain my_domain_integer not null;

I think it must have been: ... my_domain integer not null;

Otherwise IB wouldn't know what kind of domain you're trying to
create.

> Create table table1
>
> id my_domain_integer;
> );
>
> Now, I want to drop this table, but the domain referenced by the
> field and the field can not delete because the references of the
> domain.

You cannot drop the domain as long as any field exists that uses
it. But you CAN drop the field while the domain exists. So if you
cannot drop the field, there must be something else referencing
it. Maybe a Foreign Key from another table? Or a View, or a Stored
Procedure? Or somebody is connected to the database and accesses
the table?

Take a good look at the error mesage you get when you try to drop the
field!

Greetings,
Paul Vinkenoog