Point well taken Claudio!!!

Now is there a statement to safely remove unused domains or am I better
to just leave them alone?

I don't know where, but I read somewhere that cleaning up domains is a
good idea.

Todd

Claudio Valderrama C. wrote:

> I'm not a frequent contributor of this list. I seldom read the headers to
> find something interesting. This thread caught my attention. I hope I
> didn't
> come too late. Otherwise, my apologies.
>
> Now, shouting:
>
> DON'T USE THE STATEMENT SHOWN BELOW!
> RDB$RELATION_FIELDS IS ONLY ONE OF THE TWO TABLES THAT LOOKUP DOMAINS
> (EITHER EXPLICIT OR IMPLICIT DOMAINS) IN RDB$FIELDS. THE OTHER IS:
> RDB$PROCEDURE_PARAMETERS => IT ALWAYS LEADS TO IMPLICIT DOMAINS, IE
> RDB$<NUMBER>.
>
> IF YOU HAVE ARRAY-BASED DOMAINS OR FIELDS DEFINED DIRECTLY, YOU WILL LEAVE
> DANGLING ENTRIES IN RDB$FIELD_DIMENSIONS, TOO. DEPENDING ON YOUR METADATA,
> YOU MAY HAVE SPOILED RDB$DEPENDENCIES "AS A PLUS".
>
> ALSO, WITH THIS COMMAND, YOU DESTROYED EVERY EXPLICIT DOMAIN (CREATE
> DOMAIN
> name) THAT YOU MAY HAVE DEFINED IN ADVANCE AND THAT YOU STILL DON'T USE.
> WORSE, FOR SOME WEIRD REASON, YOU COULD WIPE OUT A SYSTEM DOMAIN, SO
> ALWAYS
> CHECK FOR
> RDB$SYSTEM_FLAG... BEING PARANOID MAY BE A GOOD SUGGESTION HERE.
>
> Maybe I should implement a command like
> DROP UNUSED DOMAINS
> in firebird...
>
> Anyway, Todd, after deleting things from system tables directly
> through DML
> and before doing DDL like "alter table", I recommend a hard commit.
>
> I think stored procedures didn't exist in the engine when Ann lost contact
> with source code for several years circa 1991.
> Keep crying. :-)
>
> C. (still somewhat astonished with this thread)
> ---------
> Claudio Valderrama C.
> Ingeniero en Informática - Consultor independiente
> http://www.cvalde.com - http://firebird.sf.net
>
>
> ""Ann W. Harrison"" <aharrison@...> wrote in message
> news:<5.1.0.14.2.20010712174231.01bd4aa0@...>...
> > At 09:29 PM 7/12/2001 +0000, Todd Brasseur wrote:
> > >Is there a quick way of getting rid of all domains in a database that
> > >aren't used by anything?
> >
> > delete from rdb$fields f where not exists
> > (select 1 from rdb$relation_fields rfr
> > where rfr.rdb$field_source = f.rdb$field_name);
> >
> > Regards,
> >
> > Ann
> > www.ibphoenix.com
> > We have answers
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
> 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
> <http://docs.yahoo.com/info/terms/>.