Creating a View in SQL Server

Video Transcript

"Hi, my name is Dave Andrews. Today I'm going to show you how to create a new view in SQL Server. Let's begin by opening up the Management Studio by clicking on the Start button, going to All Programs, Microsoft SQL Server, and let's select the Management Studio. It's going to begin by asking me what database I want to connect to; I'll just use the defaults. Let's expand Databases, and My Database, and Tables, and as you can see, I have a table called People. If I open that table, here's my People table that I've opened up, and as you can see, it has one person in it, and that's Dave. Let's create our new view by expanding Views and then right-clicking on Views and saying New View. Now, a view allows you to create a read-only table, basically, that will only return data, and not allow anybody to edit or change it. It's going to ask you what table we want to work with, and we're going to say People. Just click Add, and then click Close. In the People table, select what columns you want to add by clicking the check box. All I want this view to do is return the persons that are in the People table. So I'm just going to have it return PersonName. It even shows you the SQL query that it's going to run. Let's save our view as View People, and say OK. Once your view is saved, we need to run it simply by clicking up here on the toolbar this little exclamation point that will run our view. You can see down here at the very bottom the results of our view, just the PersonName, Dave. My name is Dave Andrews, and I've just showed you how to create a new view in Microsoft SQL Server."