3.2. Create and Alter Databases
SQL Server stores almost all of its data, indexes, and configurations in databases. When you install a SQL Server instance, you get four systems databases by default. The installer creates these for you automatically.
The master database is essentially the master catalog for the entire server instance. It stores all instance-level configuration information and instance-level artifacts such as server logins. You can think of the master database as everything that SQL Server knows about itself.
The model database serves as the template for all new user databases that you will create on an instance. When you create a new database, you get a copy of the model database. Adding artifacts such as tables ...