Well, thaks to you, but I´m using QuickDesk 2, I can see all the dependences of the fields, domains and all. I can not find what happed.........anyway, thanks.

Note:
In las days, i´d trie to delete a table, and FireBird say that "you can drop because CLIENTES_S exists.....CLIENTES_S was a deleted StoredProcedure....

Then. I was create again this stored procedure, and now ít can ready to drop the Stored Procedure first and the Table later........

FireBird bug?, Maybe. Anyway, FireBird Interbase is enogth to me, in spite of the little bugs.

----- Original Message -----
From: Paul Vinkenoog
To: ib-support@yahoogroups.com
Sent: Wednesday, May 21, 2003 11:37 AM
Subject: Re: [ib-support] I can not drop a Field.....


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


Yahoo! Groups Sponsor



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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