>>>>>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.
>
>Not on the client side. In SSMS the server will warn (and block) you if you violate a constraint.

Not if the constraint is ON DELETE CASCADE.