From the course: Developing Microsoft SQL Server 2016 Databases

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Create and alter tables

Create and alter tables - SQL Server Tutorial

From the course: Developing Microsoft SQL Server 2016 Databases

Start my 1-month free trial Buy for my team

Create and alter tables

“

- [Narrator] Now that we know a bit about table design and data types, let's see this in action by creating a few tables in SQL Server Management Studio. I've loaded the script for this exercise, and we'll step through it one piece at a time to get a feel for how objects can be created using the SQL language. Before I do, though, there's one small change to the default interface that I want to make. I can turn on line numbers, which will make following along a little bit easier, by going up to the Tools menu, coming down to Options, choosing Text Editor from this list here, and expanding that open, then choosing Transact SQL, and we'll expand that open, and the checkbox that I want is this one here called Line Numbers. I'll go ahead and place a check box there and say okay to that. That'll add line numbers inside of my SQL editor. Now that that change is made, let's go ahead and turn our attention to the script. At…

Contents