From the course: Microsoft SQL Server 2016 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Understanding data column options - SQL Server Tutorial
From the course: Microsoft SQL Server 2016 Essential Training
Understanding data column options
- [Instructor] Now let's look at some of the options for the individual columns in a table. I'll go back to the table I created in the previous video. I'm going to right-click on it and go to Design. That will bring up the same interface we used when we created the table. The first thing I want to do is set one of these columns to be a primary key. On the toolbar, there is a icon that looks like a key. It is in the upper right-hand corner. It looks like a key and when we hover our mouse over it, it says, "Set Primary Key" so I'll click on that. And then next to that Column Name, a little gold key icon has appeared showing this is the primary key. I also want to look at the bottom half of this interface where we see Column Properties. We have a number of different things we can set for these column properties. This will change depending on what data type you've chosen. So this particular column is the integer data type, so we get slightly different options than we would get if this was…
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.
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.