Question

Write and test a set of SQL statements that will drop the following tables:

a. Engineers
b. Faculty
c. Classes
d. ClassEnrollments

Answer 1

To drop the tables in SQL, you can use the DROP TABLE statement followed by the table name. Here is an example of how to drop each of the four tables.

Step-by-step explanation:

To drop the tables in SQL, you can use the DROP TABLE statement followed by the table name. Below is an example of how to drop each of the four tables:

• Dropping the Engineers table:
• DROP TABLE Engineers;
• Dropping the Faculty table:
• DROP TABLE Faculty;
• Dropping the Classes table:
• DROP TABLE Classes;
• Dropping the ClassEnrollments table:
• DROP TABLE ClassEnrollments;