DROP VIEW IF EXISTS v1; CREATE OR REPLACE VIEW v1 AS SELECT INTERVAL(55,10) AS my_col; SHOW TABLES; Tables_in_test v1 # The result log is disabled. SELECT INTERVAL(55,10) AS my_col; SHOW CREATE VIEW v1; SELECT * FROM v1; DROP VIEW v1;