implement and test drop temporary table ... and show create table statements

implement and test drop temporary table ... and show create table statements #8116