Delete tables with DROP TABLE
Obviously, the university_professors
table is now no longer needed and can safely be deleted.
For table deletion, you can use the simple command:
DROP TABLE table_name;
This exercise is part of the course
Introduction to Relational Databases in SQL
Exercise instructions
Delete the university_professors
table.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Delete the university_professors table
___ ___ university_professors;