Delete

Question

Post reply

Delete

Igor Micev

SSC-Dedicated

Points: 33109
More actions
March 23, 2015 at 9:55 pm

#302338

Comments posted to this topic are about the item Delete
Igor Micev,My blog: www.igormicev.com
March 24, 2015 at 5:54 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply

Umer Akram SSC-Insane Points: 22209 More actions · Answer 1

Umer Akram

SSC-Insane

Points: 22209

March 24, 2015 at 1:19 am

#1785885

Nice question Igor, Thanks for sharing

Carlo Romagnano SSC-Insane Points: 22601 More actions · Answer 2

Carlo Romagnano

SSC-Insane

Points: 22601

March 24, 2015 at 2:08 am

#1785888

Extremely easy!

Why 2 points?

🙂

sipas Hall of Fame Points: 3828 More actions · Answer 3

Carlo Romagnano (3/24/2015)
Extremely easy!
Why 2 points?
🙂

Speak for yourself - plenty of people get confused about multiple foreign keys and cascade deletes. They're all extremely easy when you know the answer.

TaylorMade SSC Eights! Points: 967 More actions · Answer 4

Explanation is really weak. The answer is . . ., here is some code . . . see! The supplied link states nothing about delete cascade constraints, which is what this is really all about. This would have been a better link:

david.gugg SSCertifiable Points: 6032 More actions · Answer 5

This is a great question. I was unclear on this my first half year as a DBA. My lack of knowledge never caused any mistakes, but once I found out I realized you'd really better understand where all the foreign keys are going in your database.

[font="Tahoma"]Personal blog relating fishing to database administration:[/font]
[font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

Carlo Romagnano SSC-Insane Points: 22601 More actions · Answer 6

sipas (3/24/2015)
Carlo Romagnano (3/24/2015)
Extremely easy!
Why 2 points?
🙂
Speak for yourself - plenty of people get confused about multiple foreign keys and cascade deletes. They're all extremely easy when you know the answer.

FKs should be in the base knowledge.

Hany Helmy SSChampion Points: 13921 More actions · Answer 7

Excellent question, thanx.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

dstrickrott SSCommitted Points: 1951 More actions · Answer 8

dstrickrott

SSCommitted

Points: 1951

March 24, 2015 at 11:30 am

#1786053

Nice question; very straightforward. Thanks Igor.

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 9

TaylorMade (3/24/2015)
Explanation is really weak. The answer is . . ., here is some code . . . see! The supplied link states nothing about delete cascade constraints, which is what this is really all about. This would have been a better link:

Both examples given in the reference of the QotD use the constraint ON DELETE CASCADE and it's a link for the foreign key relations. Additionally the example is an extra way to see what is the question really asking. The question is simple one, anyway. I think I shouldn't have written something special as an explanation. I agree that one more reference could have been added.

Igor Micev,My blog: www.igormicev.com