How to delete data from Product table by ProductID in AdventureWorks

• manhthao.dn

  SSC Rookie

  Points: 42

  More actions

  August 23, 2012 at 2:09 am

  #263219

  I want to create a procedure to delete Production.Product table by ProductID in AdvetureWorks Database.

  How to do it? Because Table Product's too many relationship 🙁

  Has anyone done this yet? Can provide me clear example to perform.

  THANKS!

• rVadim

  Hall of Fame

  Points: 3969

  More actions

  August 23, 2012 at 3:01 am

  #1529121

  I can think of 3 options:

  1. Delete data in all related tables first.

  2. Drop all relationships first.

  3. Change relationship rules for Delete (to Cascade, for example).

  --Vadim R.