Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2006
    Posts
    1

    Unanswered: why using One-to-One relationship

    Hey,
    I know I'm asking a stupid question but I need to get a clear response please:
    why using One-to-One relationship instead of meging the 2 tables in only one?
    thanks.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    if you get paid by the table, obviously it's buku more cashola

    if you want to avoid NULLs for ever and ever, amen

    if the extra data is 6 gigabytes and you don't want that sitting in the middle of the row

    if the extra data has relationships of its own that don't pertain to the main table

    helps?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Dec 2002
    Posts
    1,245
    One other reason:

    Maybe the data needs an additional layer of security and you want to avoid using column level security in SQL Server.

    Regards,

    hmscott
    Have you hugged your backup today?

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    ...but most of the time, it is better to merge the data into a single table.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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