The DROP command allows us to remove entire database objects from our database. For example, if we want to permanently remove the personal_info table that we created, we'd use the following command:
DROP TABLE personal_info
Similarly, the command below would be used to remove the entire employees database:
DROP DATABASE employees
Use this command with care! Remember that the DROP command removes entire data structures from your database. If you want to remove individual records, use the DELETE command
of the Data Manipulation Language.
If you would like to learn more about the Structured Query Language, read Introduction to SQL
or sign up for our free Learning SQL e-mail course