title: SQL Server Trigger to DELETE one record from multiple tables
body: <p>I know this can be done with foreign keys but I cannot add them or something weird happens when I am inserting new records. There are a lot of stored procedures in this database and I don't know what they do since I know nothing about stored procedures. I was hoping someone could help me figure out a trigger that will delete a specific ProductID when I delete it from the Product table. It is also located in tables called CompanyLink, TargetLink, and CategoryLink. </p>
  
  <p>As of right now, when I delete the ProductID from the Product table, I have to manually delete it from the other 3 tables it was inserted into.</p>