implement drop temporary table ... and display temporary in show create table statements

implement drop temporary table ... and display temporary in show create table statements #12569