Question

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

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

Answer 1

select * into new_table from old_table

SQLServer和Oracle不一样

Answer 2

select * into $$ from ###

Answer 3

有什么用呢，直接复制粘贴改下表名就行[