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.
Learning More
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.
