Microsoft SQL Server 2019: A Beginner’s Guide 7th Edition

Chapter 15 - System Environment of The database engine

• System Databases
  • master: most important system database of the Database Engine. It comprises all system tables that are necessary for your work. For example, the master databases contains informa
  • model
  • tempdb
  • msdb
  • resource: ‘hidden’ system database, which is used to store system objects, such as system stored procedures and functions