Professional Web Applications Themes

Foreign Keys - advantage ? - MySQL

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

  1. #1

    Default Foreign Keys - advantage ?

    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


    NA Guest

  2. #2

    Default Re: Foreign Keys - advantage ?

    NA news wrote: 

    Things like "cascade on delete" save programming


    Paul Guest

  3. #3

    Default Re: Foreign Keys - advantage ?

    On 20.02.2007 22:09, Paul Lautman wrote: 
    >
    > Things like "cascade on delete" save programming[/ref]

    .... and make the DB maintain consistency automatically.

    robert
    Robert Guest

Similar Threads

  1. Foreign keys tut
    By frizzle in forum MySQL
    Replies: 2
    Last Post: July 18th, 05:45 PM
  2. foreign keys and indexes
    By Bill in forum Informix
    Replies: 3
    Last Post: February 9th, 05:00 AM
  3. foreign keys
    By Sybrand Bakker in forum Microsoft Access
    Replies: 2
    Last Post: July 25th, 10:04 PM
  4. DMO + Foreign Keys
    By oj in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 8th, 05:58 AM
  5. SQL DMO + Foreign Keys
    By Steven Campbell in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 4th, 09:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139