DROPPING A VIEW

Create and drop a view in the current database:

CREATE VIEW few_rows_from_t1 AS SELECT * FROM t1 LIMIT 10;
DROP VIEW few_rows_from_t1;

Create and drop a view referencing a table in a different database:

CREATE VIEW table_from_other_db AS SELECT x FROM db1.foo WHERE x IS NOT NULL;
DROP VIEW table_from_other_db;

Found a mistake? Have a question or improvement idea? Let me know.

Table Of Contents