SQL Server allows you to define cascading ... and some situations where you can use them. The following script sets up the tables that I will use to look at cascading referential constraints ...

Connect to your SQL Server instance, then in the object explorer pane drill down and highlight a container, such as Tables ... presents itself to generate a script of the said job.