From the course: SQL Server 2014 Essential Training
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Creating a view - SQL Server Tutorial
From the course: SQL Server 2014 Essential Training
Creating a view
- [Voiceover] So here inside of Management Studio, if we open up AdventureWorks 2014, we see a number of options underneath it. We've already worked with Tables, and now we're going to talk about Views. If we open up Views, we'll see some of the Views that were already created for us, but let's go ahead and create our own. So I will right-click on Views, and the very top option that comes up is New View, which takes me to an interface asking me which Tables I would like for the View. For this particular View, I would like to include the Customer Table and also the Person Table. I'll add both of those, and then I'll hit Close on this dialog. And that takes us to an interface where we see the two tables, Customer and Person. We some of the different fields, and we have checkboxes available to us to check off which fields we're interested in. So in the Person Table, I am interested in FirstName and LastName, and in the Customer Table, I'm interested in AccountNumber. Once I've clicked on…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.