Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Mattias Fagerlund Strict Database Standards and Conventions RE: Strict Database Standards and Conventions

  • December 17, 2001 at 6:13 am

    #421173

    quote:

    My question regards foreign keys: what if two tables have a foriegn key to the same field on a third table - how is this column then named?

    I'm not quite sure I unserstand you here, but; Foreign keys are always named using their "domestic" name - the name they have in their home table.

    If table T0201_AGENT and T0301_DEPARTMENT both have foreign keys that refer to the table T0101_CONTACT, then both (foreign key) columns would be named T0101_CONTACT_ID. Since they're on separate tables, it shouldn't pose a problem.

    Hope that answered your question, if it didn't, please elaborate, and I'll give it another shot.

    m

    Edited by - mattias on 12/17/2001 06:15:53 AM