Alpha Video Training
Results 1 to 6 of 6

Thread: Identifying Relationship impact

  1. #1
    Member
    Real Name
    Joe Chasko
    Join Date
    Aug 2011
    Location
    Sacramento, California
    Posts
    43

    Default Identifying Relationship impact

    I'm confused about Identifying Relationships in MySQL.

    Just how does the database function change when you specify that an FK is an Identifying Relationship?

  2. #2
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    4,406

    Default Re: Identifying Relationship impact

    Ted Giles
    Example Consulting - UK
    .

    http://ec12.example-software.com//
    See our site for Alpha Support, Conversion and Upgrade.

  3. #3
    Member
    Real Name
    Joe Chasko
    Join Date
    Aug 2011
    Location
    Sacramento, California
    Posts
    43

    Default Re: Identifying Relationship impact

    Thank you. I understand the concept, but not the impact. How does this change the database function? I couldn't find anything on that.

  4. #4
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    4,406

    Default Re: Identifying Relationship impact

    I think you need an SQL forum rahter than Alpha for that level of detail.
    Ted Giles
    Example Consulting - UK
    .

    http://ec12.example-software.com//
    See our site for Alpha Support, Conversion and Upgrade.

  5. #5
    Member
    Real Name
    Joe Chasko
    Join Date
    Aug 2011
    Location
    Sacramento, California
    Posts
    43

    Default Re: Identifying Relationship impact

    It's not about SQL, per se. What does it mean to choose "Identifying Relationship" for a foreign key. Not why you do it. What does it affect?

  6. #6
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    4,406

    Default Re: Identifying Relationship impact

    Display the attached Set
    Disect it to see the different relationships
    Attached Files Attached Files
    Ted Giles
    Example Consulting - UK
    .

    http://ec12.example-software.com//
    See our site for Alpha Support, Conversion and Upgrade.

Similar Threads

  1. FYI Row Expander Performance Impact
    By James Nicholson-Plank in forum Application Server Version 10 - Web/Browser Applications
    Replies: 2
    Last Post: 04-26-2010, 06:48 PM
  2. High Impact eMail 4.0 Professional
    By EAC in forum Application Server Version 8
    Replies: 1
    Last Post: 10-01-2009, 11:27 AM
  3. Identifying Records
    By Thomas Holt in forum Alpha Five Version 4
    Replies: 4
    Last Post: 05-17-2006, 01:26 PM
  4. Identifying OLE type in field
    By Steve Bovino in forum Alpha Five Version 6
    Replies: 0
    Last Post: 07-07-2005, 05:13 PM
  5. Identifying clients
    By Don Hutchinson in forum Alpha Five Version 6
    Replies: 4
    Last Post: 04-07-2005, 02:34 AM

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
  •