--disable_abort_on_error --disable_warnings DROP SCHEMA IF EXISTS dbtest1; --enable_warnings CREATE SCHEMA dbtest1; # Just to be sure, that the new SCHEMA is not our current default SCHEMA. USE test; CREATE TABLE dbtest1.t1 (f1 BIGINT); CREATE VIEW dbtest1.v1 AS SELECT * FROM dbtest1.t1; SHOW CREATE TABLE dbtest1.t1; SHOW CREATE TABLE dbtest1.v1; SHOW CREATE VIEW dbtest1.v1;