What's wrong with foreign keys?

Posted by kronoz on Stack Overflow See other posts from Stack Overflow or by kronoz
Published on 2008-09-17T13:25:54Z Indexed on 2010/06/11 19:33 UTC
Read the original article Hit count: 156

I remember hearing Joel mention in the podcast that he'd barely ever used a foreign key (if I remember correctly). However, to me they seem pretty vital to avoid duplication and subsequent data integrity problems throughout your database.

Do people have some solid reasons as to why (to avoid a discussion in lines with SO principals)?

Edit: "I've yet to have a reason to create a foreign key, so this might be my first reason to actually set up one."

© Stack Overflow or respective owner

Related posts about database

Related posts about subjective