Introduction to SSMS interface, Microsoft SQL Server Management Studio

Опубликовано: 07 Октябрь 2024
на канале: it Tips

112

Microsoft SQL Server Management Studio is a powerful and user friendly software to manage the data in database. This software provided many important tools for data manipulation. In this session we will explore SSMS interface and it's features. SSMS is flexible tool and can be configured according to the user requirements. It provide tool windows and database explorer that can be used to quickly navigate among different databases.
In SSMS we can customize the main interface after adding or removing windows components such as query designer, SQL editor, Table designer, XML editor and many more. In main command editor we can change the font size and font style that make it attractive and enhanced user experience. There is menu that contains two different options for customization of interface, these are customize and options.
In this session we will also learn that how we can create database using SSMS, and how to select different databases using SQL command and as from from drop down menu.
We can switch to different database object using object explorer window.