/* swaptable.sql - swapping two tables by their name
(c) 2006 legolas558
Public Domain */
/* The rename is done from left to right, this allows the usage of the following
statement to swap two table names; note: temp_name table must not exist */
RENAME TABLE table_a TO temp_name,
table_b TO table_a,
temp_name TO table_b;