MySQL - Foreign keys

Discussion in 'Techie Discussion' started by SilverHood, Mar 18, 2005.

  1. SilverHood

    SilverHood Part of the furniture

    Are foreign keys declared in the same way as in oracle?

    IE (using oracle sql as an example)

    OrderID references BarOrder(OrderID)
    Foreign key (BarID, JobID) references Bar)

    The tool we've been given to use doesn't seem to do the relationships properly, so will have to do it manually.

    Any help appreciated :)
  2. Jonty

    Jonty Fledgling Freddie

  3. SilverHood

    SilverHood Part of the furniture

    Ah cheers, they aren't needed then :)

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.