What are the default databases in SQL Server

Article for: MySQL

On every SQL Server instance there is a number of default system databases. Those are"

  • master - keeps the information for an instance of SQL Server.
  • msdb - used by SQL Server Agent.
  • model - template database copied for each new database.
  • resource - read only database that keeps system objects that are visible in every database on the server in sys schema.
  • tempdb - keeps temporary objects for SQL queries.

View in SSMS.