From the course: MySQL Database Administration

Unlock this course with a free trial

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

Dropping schemas and tables

Dropping schemas and tables - MySQL Tutorial

From the course: MySQL Database Administration

Start my 1-month free trial Buy for my team

Dropping schemas and tables

“

- [Instructor] All right, in this lecture, we're going to talk about dropping schemas and tables. I've said this before when I talked about dropping columns, and I mentioned it briefly about schemas and tables as well. So the most important thing I'll say about this is that you should be careful. If you drop the wrong schema or the wrong table, it can totally break some sort of a backend process that could have major ramifications for your company. That could be as minor as breaking reporting and then people couldn't get information that they need. Or it could be as major as actually impacting your product, if say you run a technology product, which relies on the backend database in order to populate the front end data that the customer is experiencing. You may drop a column or a table or a schema that the backend process is looking for, which will then throw an error, which could then actually break the entire experience. So this can be super dangerous. In reality, there's not a ton…

Contents