Best way to achieve a delete cascade event ?

Hi there quick question when a user record is delete from my user table :

Do I have to set a trigger into my user table then query all records for each tables link to this user and then simply delete all records with a for each loops ?