What are master tables in database?

Question

« 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 master table in database example?

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.

What is master table in SQL Server?

The master database records all the system-level information for a SQL Server system. This includes instance-wide metadata such as logon accounts, endpoints, linked servers, and system configuration settings.

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 the role of master table?

The Master Table is used to track the detailed progress information of a Data Pump job: * The current set of dump files. * The current state of every object exported or imported and their locations in the dump file set.

Expert · Answer