From the course: Learning SQL Server 2017
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Tour the SSMS interface - SQL Server Tutorial
From the course: Learning SQL Server 2017
Tour the SSMS interface
- [Instructor] Management Studio, or SSMS, will serve as the main interface when you're working with SQL Server. After logging into the server, using my Windows Authentication Account, we'll see this very basic interface that I have on my screen now. Across the top of the screen is a group of icons that collectively make up something called the Standard Toolbar. If we visit the View menu and then come down to Toolbars, we'll see that we have over a dozen different toolbars that can be activated. And right now, the Standard toolbar is the only one that's on. Some toolbars will activate automatically as you perform tasks within Management Studio. For instance, I'll go ahead and click off of the menu somewhere to dismiss it, and then press the New Query button up here on the top. This will open up a new window, ready for us to type in a transact SQL command. You'll also notice that we have an additional row of tools now, which includes a dropdown menu for the database that we want to…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.