Subject | Re: [ib-support] Removal of domains |
---|---|
Author | Ivan Prenosil |
Post date | 2001-07-17T09:50:54Z |
> When I created a database I did not use domains, so interbase madeWhen you assign new domain to field by
> 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 ?
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