its urgent please help........
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: its urgent please help........

  1. #1
    Join Date
    Mar 2001
    Posts
    38
    VARIABLE ONE TO ONE RELATION:
    EMAIL
    ID ADDRESS
    1
    2

    PHONE
    ID NUMBER
    3
    4

    EMP
    ID C_ID(EMAILID,PHONEID)
    01 1
    02 2
    03 4

    WHAT KIND OF CONSTRAINT I SHOULD PUT ON C_ID IN EMP TABLE SO THAT IT REFERENCE TO EITHER PHONE OR EMAIL;
    el472@hotmail.com

  2. #2
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    I am not aware of any one constraint that can do this. May be someone else has any idea.

    I would suggest writing an After Update and Insert trigger on that column to check the values.

    - Rajeev
    Rajeev Suri

  3. #3
    Join Date
    Mar 2001
    Posts
    38
    thanks rsuri,
    can you give an eg.

    thanks aain
    el472@hotmail.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
  •  



Click Here to Expand Forum to Full Width