Views
9. Deleting views
Revision

Instruction

Nice! Okay, one last thing you need to know: views can be deleted. When you delete a view, you only delete the remembered query. The data or the table itself are not deleted in this way. Take a look:

DROP VIEW current_course;

The above instruction will delete the view current_course.

Exercise

Delete the view current_lecturer.

Stuck? Here's a hint!

Type

DROP VIEW current_lecturer;

Console

Code editor

Result

TableConsole