ql/src/test/queries/clientpositive/show_create_table_temp_table.q

create database tmpdb;
create temporary table tmpdb.tmp1 (c1 string, c2 string);
show create table tmpdb.tmp1;
drop table tmp1;
create temporary table tmpdb.tmp_not_null_tbl (a int NOT NULL);
show create table tmpdb.tmp_not_null_tbl;
drop table tmpdb.tmp_not_null_tbl;

drop database tmpdb;