How to create a empty temporary table from another tables schema?

Question

Is there an idiomatic way of doing this?

Answer 1

Here is a script that claims to work on SQL 2005.

Answer 2

This works in most DBs:

create table blah as
select * from foo where 1=0

Note that this will not copy and PKs, indexes, etc.

Answer 3

select * into x_temp from tbl where 1 = 0