What Is The Difference Between 1:1 And 1:M Extension Tables

What Is The Difference Between 1:1 And 1:M Extension Tables


  • 23 Dec, 2011

    1:1 extension table is like an extension to the base table. if we do not have the required table space in the base table for craeting new extension columns, we will use the 1:1 extension table's columns using an implicit join.in contrast, 1:M extension tables are used for parent child relationship with the base table. where the 1:M extension has only related to the base table. for example, for a contact (S_CONTACT) there will be a number of specialities in the extension table(S_CONTACT_XM) with the parent child relationship.

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.