From the course: Learning Microsoft SQL Server 2019
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 Microsoft SQL Server 2019
Tour the SSMS interface
- [Instructor] Management Studio or SSMS, will give us the main interface that we're going to use when we're working with SQL Server. After logging into my sever using my Windows Authentication account, we're going to see this very basic interface. Across the top of the screen is a grouping of icons that collectively make up something called the standard toolbar. If we visit the view menu and then come down to toolbars you'll see that there's actually over a dozen different toolbars that we can activate here in SSMS, including the standard toolbar that's currently activated right now. Some of these toolbars will activate automatically as you perform tasks within Management Studio. For instance if we click off of this menu somewhere to dismiss it, and then press the new query button here on the standard toolbar, we'll get a new SQL window over here on the right. This is where we'll come to enter in transact SQL commands to the server. You'll also notice that we have an additional row…
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.