Hi all,

I've received this database from a customer saying he cannot drop a table
because of left dependencies. However, there are no triggers or constraints
defined.

I've look in the RDB$DEPENDENCIES table and found records like this:

RDB$DEPENDENT_NAME -- RDB$DEPENDED_ON_NAME -- RDB$FIELD_NAME
DB$943 -- ORD_CUR -- TO_ID_KEY
DB$943 -- ORD_CUR -- FROM_ID_KEY


RDB$DEPENDENT_TYPE RDB$DEPENDED_ON_TYPE
2 -- 0
2 -- 0

The values for RDB$DEPENDENT_TYPE RDB$DEPENDED_ON_TYPE say it should be a
trigger to a table - however, no triggers with names DB$xxx can be found! --
please not: DB$xxx and NOT RDB$xxx

Any idea what statements (or tools?) create DB$xxx dependent names?
--
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."