What is master table and detail table?

Question

In a relational database, a master table can be linked to one or more related (detail) tables by key fields. A detail table may in turn act as a master table, with other key fields linked to other detail tables. Each detail table contains a masterRowset property pointing to its master table.

What is master and detail tables?

Master-Detail Tables is an add-on for wpDataTables which allows you and your site visitors to see details for each row with a simple click.

What is master table and detail table in SQL?

Master and detail reports show hierarchical information. The information is normally retrieved from multiple tables that have a one-to-many relationship, such as customers and orders. The customer information is the master, and the orders are the detail.

What is master table?

« Back to Glossary Index. The tables that hold the records containing general information about the participants or objects of transactions within a module. In General Ledger the master table contains the account names, numbers, and balances.

What is detail table?

A detail table is a field in the Data Model that contains a record set instead of a single value. Detail tables contain transactional data. They are created when an Extract step is added within a Repeat step; see Extracting transactional data.

Expert · Answer