1use test; 2ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10; 3DROP TABLE IF EXISTS t_10; 4DROP TABLE IF EXISTS t_100; 5DROP TABLE IF EXISTS t_1000; 6DROP TABLE IF EXISTS tp; 7DROP TABLE IF EXISTS tsp; 8DROP TABLE IF EXISTS tsp_00; 9DROP TABLE IF EXISTS tsp_01; 10DROP TABLE IF EXISTS tsp_02; 11DROP TABLE IF EXISTS tsp_03; 12DROP TABLE IF EXISTS tsp_04; 13DROP TABLE IF EXISTS t_empty; 14DROP TABLE IF EXISTS t_null; 15use test; 16ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10; 17DROP TABLE IF EXISTS t_10; 18DROP TABLE IF EXISTS t_100; 19DROP TABLE IF EXISTS t_1000; 20DROP TABLE IF EXISTS tp; 21DROP TABLE IF EXISTS tsp; 22DROP TABLE IF EXISTS tsp_00; 23DROP TABLE IF EXISTS tsp_01; 24DROP TABLE IF EXISTS tsp_02; 25DROP TABLE IF EXISTS tsp_03; 26DROP TABLE IF EXISTS tsp_04; 27DROP TABLE IF EXISTS t_empty; 28DROP TABLE IF EXISTS t_null; 29use test; 30ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10; 31DROP TABLE IF EXISTS t_10; 32DROP TABLE IF EXISTS t_100; 33DROP TABLE IF EXISTS t_1000; 34DROP TABLE IF EXISTS tp; 35DROP TABLE IF EXISTS tsp; 36DROP TABLE IF EXISTS tsp_00; 37DROP TABLE IF EXISTS tsp_01; 38DROP TABLE IF EXISTS tsp_02; 39DROP TABLE IF EXISTS tsp_03; 40DROP TABLE IF EXISTS tsp_04; 41DROP TABLE IF EXISTS t_empty; 42DROP TABLE IF EXISTS t_null; 43