>>>Hi,
>>>
>>>Typically you can include the ON DELETE CASCADE in the FK Constraint. But I was wondering if it is possible to have a ON DELETE CASCADE without the constraint? TIA.
>>
>>No,
>>Unless you do this in a trigger.
>
>And you effectively have made a constraint except the server won't warn you about it.
No,
Constraint can't warn you, trigger also can't warn you, you must warn the user in your front end BEFORE deleting.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.