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

Creating a view - SQL Server Tutorial

From the course: SQL Server 2014 Essential Training

Start my 1-month free trial

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…

Contents