Hello Hans,

> My database been operational without flaws for last 12 years since FB 1.x,
> I have no views :)

The following statement will give a stastic of dependencies without a
field name involved:

select
rdb$dependent_type
, rdb$depended_on_type
, count(*)
from
rdb$dependencies
where
rdb$field_name is null
group by
rdb$dependent_type
, rdb$depended_on_type


With the result set, we might be able to point you to dependencies where
a field name is not involved.

It does not need to be view, e.g. do you have stored procedures or
triggers referencing a generator? Just an example. ;-)


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/

> ----- Original Message -----
> From: "Thomas Steinmaurer" <ts@...>
> To: <firebird-support@yahoogroups.com>
> Sent: Wednesday, December 17, 2008 11:32 PM
> Subject: Re: [firebird-support] RDB$DEPENDENCIES row entries with
> RDB$FIELD_NAME = NULL
>
>
>>> I just noticed numerous row entries
>>> in RDB$DEPENDENCIES with RDB$FIELD_NAME = NULL
>>>
>>> Now using FB2.1, but it looks like they where created already
>>> in earlier versions.
>>>
>>> Can I just delete these entries, or do they serve a purpose ?
>> They do. For example a view is dependent on a table. Or a procedure is
>> dependent on a table ...
>>
>> --
>> Best Regards,
>> Thomas Steinmaurer
>> LogManager Series - Logging/Auditing Suites supporting
>> InterBase, Firebird, Advantage Database, MS SQL Server and
>> NexusDB V2
>> Upscene Productions
>> http://www.upscene.com
>> My blog:
>> http://blog.upscene.com/thomas/
>>
>> ------------------------------------
>>
>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>
>> Visit http://www.firebirdsql.org and click the Resources item
>> on the main (top) menu. Try Knowledgebase and FAQ links !
>>
>> Also search the knowledgebases at http://www.ibphoenix.com
>>
>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>> Yahoo! Groups Links
>>
>>
>>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>