Windows

MS SQL SMS osnove

velda April 27, 2020

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 −
Master
Model
MSDB
Tempdb
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.
*****

Dobar link.