I will delete the foreign keys, and need to adda few checks in side
firebird db.

TABLE A

ID
IDTABLEA
VALUE

TABLEB
ID
VALUE

Foreign Key is

IDTABLEA = ID (IN TABLEB)

How can i check with a trigger deleting values in TABLEB as dont exist
in TABLEA?

I dont need to cascade the value ID (IN TABLEB), it never changes at
application level.

TIA

German.