From the course: Microsoft SQL Server 2019 Essential Training

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Solution: Create tables with T-SQL commands

Solution: Create tables with T-SQL commands - SQL Server Tutorial

From the course: Microsoft SQL Server 2019 Essential Training

Start my 1-month free trial Buy for my team

Solution: Create tables with T-SQL commands

“

- [Instructor] In this challenge, we were tasked with creating a table to hold details about fitness classes for a local gym. We're given a list of requirements and we just need to make sure that the table that we create has columns that are appropriately structured for the given data that we want to insert into the table. Now, we're given this sample answer that has the insert statement down below, so we can see that it'll eventually add in three rows of information into the fitness class schedule. And we just need to make a table that will accommodate all of this data. All right, let me come up here to line number three and we'll get started with a create table statement. And the name of the table is going to be Fitness Class Schedule. Then we'll just open a parentheses and I'll move that closing parentheses down. And I'm going to add my semicolon at the very end right now just for good measure so that I don't forget it later. Okay, we'll come inside and we'll start filling in the…

Contents