The ON DELETE CASCADE and ON DELETE RESTRICT are the foreign key properties and you set them when you create the relationship between two tables.
If you set the relationship to be ON DELETE CASCADE, when you run a DELETE statement on a “parent” table, it will automatically DELETE all the corresponding rows from the “child” table. But the RESTRICT (which is the default foreign key relationship behavior) is when you try to delete a row from the “parent” table and there is a row in the “child” table with the same ID, it will fail, complaining about the existing child rows.
Either way, you don’t need to mention anything in your DELETE clause.
I also wrote a blog post about the different rules for DELETE and UPDATE commands in more detail here:
SQL Server Foreign Key Update and Delete Rules | Koukia