如果是oracle数据库
create table table_B as select * from table_A where 1=1;
where 条件如果写成1=2,将只复制table_A的表结构给table_B
如果是MS SQL(Microsoft SQL Server)
select * into table_B from table_A where 1=1;
where 条件如果写成1=2,将只复制table_A的表结构给table_B
如果是oracle数据库
create table table_B as select * from table_A where 1=1;
where 条件如果写成1=2,将只复制table_A的表结构给table_B
如果是MS SQL(Microsoft SQL Server)
select * into table_B from table_A where 1=1;
where 条件如果写成1=2,将只复制table_A的表结构给table_B