DROP 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 embedded program, drop two views.
EXEC SQL DROP VIEW tempview1, tempview2;