DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Pk

  1. #1
    Join Date
    Apr 2010
    Posts
    1

    Talking Pk

    Is this statement true: Records are never deleted from the parent tables, and primary keys are never updated in the parent tables.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    what?

    makes no sense, why wouldn't data be deleted or updated

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    True that the PK itself should generally not ever be updated, but there is no reason whatsoever it can't be deleted. How does on delete cascade work for FKs?

Posting Permissions

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


Click Here to Expand Forum to Full Width