+ Reply to Thread
Results 1 to 3 of 3

Thread: Pk

  1. 04-08-2010 06:09 PM #1
    anabanana99
    anabanana99 is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  2. 04-08-2010 06:30 PM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    what?

    makes no sense, why wouldn't data be deleted or updated
    Reply With Quote Reply With Quote
  3. 04-09-2010 08:35 AM #3
    stecal's Avatar
    stecal
    stecal is offline Super Moderator
    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?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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

Forum Rules

 Click Here to Expand Forum to Full Width