Drop a View

The first statement in the editor creates a view called on_leave_students, a one-off report that is no longer wanted. Leave that statement in place and, below it, write the statement that removes the view, so that nothing called on_leave_students exists when your script ends. Keep the final SELECT too: it proves that dropping a view never deletes rows from students.

Expected result:

Table on_leave_students
✓ on_leave_students is dropped

+----------+
| students |
+----------+
|       30 |
+----------+
1 row

Hints2 available

Topics:

Views & Indexes

Code Editor

Tab to indent (Esc then Tab to move on) · Ctrl+Enter to run · Ctrl+Space to expand shortcuts (sel, ins, desc)

Results

Run your SQL to see every statement's output here, then how it compares with the expected answer.

Not sure what is in a table? SHOW TABLES lists them and DESCRIBE students shows the columns — or open the database browser on the left.