Member Avatar for manhthaodn

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
  • 172 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by manhthaodn
Member Avatar for pritaeas

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

Member Avatar for manhthaodn

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

Member Avatar for Taywin

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...

Member Avatar for manhthaodn

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!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.