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