Results 1 to 2 of 2

Thread: Referential Integrity across Schemas

  1. 07-12-2004, 02:30 AM #1
    shweta
    shweta is offline Registered User
    Join Date
    Jul 2004
    Posts
    3

    Referential Integrity across Schemas

    Hi All

    I am having 2 Schemas , SAY,
    S1 and S2. S1 has T1 table with primary Key as id1 and similarly schema S2 has T2 as the table and Id2 as the primary key

    I want a referential integrity like
    S1.T1.ID1 refers to S2.T2.ID2

    hOW DO I DO IT iN MYSQL??


    REGARDS
    SHWETA
    Reply With Quote Reply With Quote
  2. 07-13-2004, 03:32 PM #2
    greenman
    greenman is offline Registered User
    Join Date
    Dec 2002
    Location
    Cape Town, South Africa
    Posts
    75
    You can read this article to find out more. Note that the tables have to be InnoDB, which is not the default table type.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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