Creates a logical view based on one or more tables
CREATE_VIEW
// Create a view based on price being over $10 CREATE VIEW OverTen AS; SELECT * FROM orders WHERE price > 10 // Create a view based on price being over $20 CREATE SQL VIEW OverTwenty AS; SELECT * FROM orders WHERE price > 20
https://www.lianja.com/doc/index.php/CREATE_VIEW
https://www.lianja.com/doc/index.php/SQL_CREATE_VIEW
Frees up all system resources allocated to a view
DROP_VIEW
DROP VIEW OverTen
https://www.lianja.com/doc/index.php/DROP_VIEW