If you see the error, it is clearly mentioned that 'test' schema is already exist, thats why u got that error. But while dropping the schema , it must be empty. ... View more

CREATE TABLE table2 LIKE table1; INSERT INTO table2 SELECT * FROM table1; These are sql queries which can be used but not working with base.. By d way nice question. I am also trying for it. ... View more