• If you set up the cascade delete correctly, that is exactly what happened.

    I did one cascade delete in Oracle before and I never set one up in SQL Server.