0

Hi,

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 :(

THANKS!

3
Contributors
4
Replies
5
Views
5 Years
Discussion Span
Last Post by manhthaodn
0

If there are FK's enforced, then you have to make sure you first delete all child records, before you can delete the product.

0

I've tried your way but don't delete data. As I know, must use Cascade Delete.

0

So you may not be doing it correctly. Here is a link to an explanation from someone who has already asked similar question on another forum. I can't explain better than that...

0

I tried but still not done.

Because Product table of the database Adventure Works has too many relationships!

Has anyone done this yet?

Database system: SQL SERVER 2008

Hi,

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 :(

THANKS!

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.