Create tables
Say you want to create a table to consolidate some useful track information into one table. This will consist of the track name, the artist, and the album the track came from. You also want to store the track length in a different format to how it is currently stored in the track table. How can you go about doing this? Using CREATE TABLE. Recall the example from the video:
CREATE TABLE test_table(
test_date DATE,
test_name VARCHAR(20),
test_int INT
)
Let's get started!
This exercise is part of the course
Introduction to SQL Server
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Create the table
___ ___ ___ (
-- Create track column
___ ___(___),
-- Create artist column
___ ___(___),
-- Create album column
___ ___(___),
);