Examples—Drop Statement
The following are drop statement examples:
1. Drop the employee and dept tables.
drop table employee, dept;
2. Drop the salary table and its index, salidx, and the view, emp_sal.
drop salary, salidx,
accounting.emp_sal;
3. In an OpenROAD program, drop two views.
drop view tempview1, tempview2;