SQL Server Management Studio is a workstation component\client tool that allows you to connect to and manage your SQL Server from a graphical interface instead of having to use the command line.
System databases are created automatically when we install MS SQL Server. Following is a list of system databases −
Resource (Introduced in 2005 version)
Distribution (It’s for Replication feature only)
Views are virtual tables that hold data from one or more tables. It is stored in the database. A view does not contain any data itself, it is a set of queries that are applied to one or more tables that are stored within the database as an object.