1 2 3 4
CREATE TEMPORARY TABLE t (i INT); CREATE or replace TABLE t AS SELECT * FROM t; DROP TEMPORARY TABLE t; DROP TABLE t;