Subject Re: [ib-support] Removal of domains
Author Ivan Prenosil
> When I created a database I did not use domains, so interbase made
> them for me (RDB$418, RDB$419, ....)
> I created domains now, and assigned those domains to the fields in
> the database.
> Now I have a zillion domains (RDB$418, RDB$419, ....) wich I do not
> use anymore.
> How can I delete these ?
> I use QuickDesk but if I look at the domains there I only see the
> domains I created myself.
> How do I remove the domains the database made ?

When you assign new domain to field by
ALTER TABLE ... ALTER ...TYPE ... command,
IB will remove unused system generated domains automatically.
When you assign new domain by direct updating system tables,
then you have to remove unused domain from system tables by hand
(DELETE FROM RDB$FIELDS WHERE ...)

Ivan
prenosil@...
http://www.volny.cz/iprenosil/interbase