Subject | Re: [ib-support] I can not drop a Field..... |
---|---|
Author | Paul Vinkenoog |
Post date | 2003-05-21T15:37:40Z |
Hi Fernando,
Otherwise IB wouldn't know what kind of domain you're trying to
create.
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
> Some day I made like this...:I think it must have been: ... my_domain integer not null;
>
> Create domain my_domain_integer not null;
Otherwise IB wouldn't know what kind of domain you're trying to
create.
> Create table table1You cannot drop the domain as long as any field exists that uses
>
> 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.
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