Hi,

At August 18, 2003, 06:25, Andrew Monteith wrote:

> In an attempt to get rid of all the columns in our database without
> domains attached, I ran this query.

> select RDB$RELATION_NAME, RDB$FIELD_NAME, RDB$FIELD_SOURCE
> from RDB$RELATION_FIELDS
> where RDB$SYSTEM_FLAG = 0
> and RDB$FIELD_SOURCE starts with 'RDB$'

> I then altered all the columns to have domains, which resulted in
> the above query returning an empty result set.

> I then ran this query

> select *
> from RDB$FIELDS
> where RDB$SYSTEM_FLAG = 0
> and RDB$FIELD_NAME starts with 'RDB$'

> and got 3447 rows as output.

> Example output
> RDB$FIELD_NAME

Those are system defined domains for the fields in your tables that
don't have an explicitly defined domain.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)