1 2 3 4 5 6
drop table if exists t1,v1; drop view if exists t1,v1; use test; create table t1 (field1 INT); CREATE VIEW v1 AS SELECT field1 FROM t1; drop view v1;