Describe 테이블전환 here

http://www.sqler.com/?mid=bSQLQA&page=88&document_srl=342114

create table taddy  (번호 int not null, name varchar(24))
 
insert taddy 
select 1,'박찬호' union all
select 2,'홍길동' union all
select 3,'김연아' union all
select 4,'유재석' union all
select 5,'강호동'
 
 
 
create table taddy_id
(번호 int identity(6,1) not null, name varchar(24))
 
 
 
alter table taddy switch to taddy_id
 
 
 
drop table taddy
exec sp_rename 'taddy_id','taddy'
 
select * from taddy