From the course: MySQL Database Administration

Unlock this course with a free trial

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

Solution: Dropping schemas and tables

Solution: Dropping schemas and tables - MySQL Tutorial

From the course: MySQL Database Administration

Start my 1-month free trial Buy for my team

Solution: Dropping schemas and tables

“

- [Instructor] All right, this is the solution video for your assignment on deleting tables and schemas. As a reminder, Amy needs your help dropping the table candy_products from the candystore schema, and she would also like you to drop the previous version of the schema, candystore_old. Let's jump into Workbench and walk through the solution. So at this point, I think you're fairly familiar with the candystore schema, but I will just very quickly run through the tables again. We have candy_products, customer_reviews and employees, and Amy wants you to drop candy_products and then drop candystore_old. So it is really as simple as this. Right click, Drop Table, and we can say, yes, Drop Now. And now that candy_products table from the candystore schema no longer exists. We can then also go into the candystore_old. So you see this is now no longer synced with the version that we're maintaining today. It still has the candy_products table. It also has some different columns in the other…

Contents