Foreign Keys - advantage ?
This is a discussion on Foreign Keys - advantage ? within the MySQL Database forums, part of the Database Forums category; As a newbie to SQL I guess the only advantage I can see of setting up Foreign Keys is to ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-20-2007
|
|||
|
|||
Re: Foreign Keys - advantage ?
NA news wrote:
> As a newbie to SQL I guess the only advantage I can see of setting up > Foreign Keys is to help ensure you don't get left with 'orphan' rows, > right ? > TIA, > Nick A Things like "cascade on delete" save programming 
|
|
02-21-2007
|
|||
|
|||
|
Re: Foreign Keys - advantage ?
On 20.02.2007 22:09, Paul Lautman wrote:
> NA news wrote: >> As a newbie to SQL I guess the only advantage I can see of setting up >> Foreign Keys is to help ensure you don't get left with 'orphan' rows, >> right ? >> TIA, >> Nick A > > Things like "cascade on delete" save programming .... and make the DB maintain consistency automatically. robert
|
Linear Mode
