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!
Latihan ini adalah bagian dari kursus
Introduction to SQL Server
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
-- Create the table
___ ___ ___ (
-- Create track column
___ ___(___),
-- Create artist column
___ ___(___),
-- Create album column
___ ___(___),
);