Creating a Table in SQL Server

Video Transcript

"Hi, my name is Dave Andrews, today I'm going to show you how to create a table in SQL Server. Lets open up our management studio, clicking on start at the bottom, going to all programs, finding Microsoft SQL Server. Lets just run the management studio. Now it's going to pop up asking me what database I want to connect to. I'm just going to connect to the local database that it came up with. Now lets find our database we'd like to add our table to, expand tables under that database, right click on tables and say new table. Now over here on the right hand side it's going to open up our table editor. The first thing we're going to do is create a column named ID because just about every table needs an ID field. After ID lets give it a data type of Integer by selecting INT. Now we want our ID to automatically increment so down here in column properties lets scroll down, expand identity specification and change is identity to yes. That will make this a unique primary key that automatically enter increments. Lets add another field. I'm just going to call it Person name and I'm going to make the type text. Now lets save our table by clicking on the save icon at the top and give it a good name. I'm going to call it people. Now lets close the design view by clicking this X. As you notice our people table is right here and we can right click on it and say open table. Here is our table opened up so that we can type in data. It's that easy to create a new table in SQL Server. My name is Dave Andrews and I've just showed you how to create a table in Microsoft SQL Server."