Different from ORACLE and MySQL, MS SQL Server does not provide Cascade delete function natively. This maybe considered as a safety feature to prevent unintentional