如何用sql server 创建与其他表具有相同表结构的表

Question

我用create table ### as select * from $$$$ where 1=2 好像不行~~~

Answer 1

select * into new_table from old_table

SQLServer和Oracle不一样

Answer 2

select * into $$ from ###