Again, looking for a trick in the question, as again the answer seemed too easy.
As temp tables are dropped at the end of the session, I assumed this is what the question was referring to... and answered as if "would the table exist"... rather than "would the table be created", which of course it would.
Noticed the DEFAULTS of NULL but didn't pay much attention to them as thought it was unusual but okay.
Ho hum! :ermm:
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]