databaseoracle-databaseforeign-keys

Why are foreign keys necessary in a database design?


Foreign keys help the programmer to manipulate data.

If a programmer is doing this already, then do we need the concept of foreign keys?

What are other uses for foreign keys?

What am I missing?


Solution

  • Foreign keys help enforce referential integrity at the data level. They also improve performance because they're normally indexed by default.