oracle中如下:
1、此法将原表中的数据一起加入
create table newname as select * from oldname;
2、只要表结构
create table namename as select * from oldname where 1=2;
1、此法将原表中的数据一起加入
create table newname as select * from oldname;
2、只要表结构
create table namename as select * from oldname where 1=2;
create table t2 as select * from t1 ;(新表与旧表相同内容)
1、此法将原表中的数据一起加入
select * into newname from oldname;
2、只要表结构
select * into newname from oldname where 1 = 2;當然sp_dboption中該database的
'select into/bulkcopy'
屬性要為true;
否則就先執行:
sp_dboption yourdatabasename,'select into/bulkcopy',true;