What is master table in database example?

Question

Master Data: Data which seldom changes. For example, if a company has a list of 5 customer then they will maintain a customer master table having the name and address of the customers alongwith other data which will remain permanent and is less likely to change. 27 февр. 2016 г.

What is a master table in a database?

« 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 an example of a table in a database?

Most relational databases contain many tables. For example, a database might have a Customers table, a Products table, an Orders table, and many more. In fact, it's not uncommon for a corporate database to contain hundreds of tables.

What called master table?

Sqlite Master listing of all database objects in the database and the SQL used to create each object.

What is difference between master and transaction table?

master data table is not changes frequently but transactional data table will change frequently. master data records will be less compared to transactional data records. customer table ie KNA1 is Master data table and VBAK ie sales order header table is transactional data table.

Expert · Answer