Background

SQL sublanguage: DDL (Data Definition Language)

In the last activity we learned how to create tables in SQL. In this activity we are going to learn how to drop a table from our database.

The syntax for dropping a table is as follows:

DROP TABLE table_name;

Additional reference material if needed: https://www.w3schools.com/sql/sql_drop_db.asp

---

Lab

Problem 1

song table

title	artist
Let it be	Beatles
Hotel California	Eagles
Kashmir	Led Zeppelin

Problem 1: In the "problem1.sql", drop the table "song"