Hi.

I am using FireBird 2.5.3
and a Database is updated from 2.2, and the database was updated from 1.5.

The database have about 150 tables and just one foreign key.

The Foreign key is from "hachu"Table to "parts"Table

This is part of definition of the tables.
ISQL display these informations.

SQL> show table parts;
OPERATIONCODE                   VARCHAR(100) Nullable
PARTSID                         INTEGER Not Null
PRODUCTCODE                     VARCHAR(100) Nullable
CONSTRAINT INTEG_152:
Primary key (PARTSID)

SQL> show table hachu;
HACHUDATE                       DATE Nullable
HACHUID                         INTEGER Not Null
HACHUNO                         VARCHAR(10) Nullable
HSU                             INTEGER Nullable
CONSTRAINT FKHACHUTOPARTS:
  Foreign key (PARTSID)    References PARTS (PARTSID) On Delete Set Null


I tried to drop the foreign key,but I could not.
SQL> alter table hachu drop constraint fkhachutoparts;

Statement failed, SQLSTATE = 42000
unsuccessful metadata update
-cannot delete
-INDEX FKHACHUTOPARTS
-there are 1 dependencies

I deleted all records of "parts" and "hachu".
I deleted all triggers of "parts" and "hachu".

But "there are 1 dependencies"

I can't also drop these tables.

SQL> drop table hachu;
Statement failed, SQLSTATE = 42000
unsuccessful metadata update
-cannot delete
-INDEX FKHACHUTOPARTS
-there are 1 dependencies

SQL> drop table parts;
Statement failed, SQLSTATE = 42000
unsuccessful metadata update
-ERASE RDB$RELATION_CONSTRAINTS failed
-action cancelled by trigger (1) to preserve data integrity
-Cannot delete PRIMARY KEY being used in FOREIGN KEY definition.

I don't understand why i can't drop the foreign key.
But i want to drop the foreign key.

Any help appreceiated.

Nobuo Watanabe