>>>>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.