Create a temporary table in SQL on the fly

Question

How to create a temporary table without first creating columns?

CREATE TABLE #Yaks ( YakID int, YakName char(30) ) select name from tempdb..sysobjects where name like '#yak%' drop table #yaks 

First you need to define a table.

Answer 1

Create a table (temp) with the same columns as the other (without copying data):

 select * into #TempTable from MyTable where 1=0 

Note. No foreign keys, indexes, etc. are created.