34,593
社区成员
发帖
与我相关
我的任务
分享修改列属性
create table bbb as select * from aaa where 1=2;
alter table bbb modify (a1 varchar2(32));
insert into bbb select * from aaa;
drop table aaa;
rename table bbb to aaa;
alter table bbb modify (a1 varchar2(32));
insert into bbb select * from aaa;
drop table aaa;
rename table bbb to aaa;
...全文
请发表友善的回复…
发表回复
lg3605119 2009-04-01
- 打赏
- 举报
select * into bbb from aaa where1=2
drop table aaa;
exec sp_rename 'bbb','aaa','table'
