Writing code should include the DROP VIEW command, the name of the view, and reflect the following syntax:
DROP VIEW nameOfview;
Note that a view created with the CREATE OR REPLACE option will automatically drop the old view of the same name and replace it with the new code. A view can be completely eradicated with the code above.
Related Standards of Learning
The student will design and apply computer programs to solve practical problems in mathematics arising from business and applications in mathematics.
The student will write program specifications that define the constraints of a given problem.