SQL Server 2008 修改表名

 有一张表

 修改起

if exists (select * from sys.objects 
where object_id = object_id(N'Table_1') 
            and type in (N'U')) 
begin 
    select * into Table_88 from Table_1 
    drop table Table_1
    select 1; 
end 
else 
    select 0;

 效果

posted @ 2013-08-07 18:02  罗马景行  阅读(287)  评论(0编辑  收藏  举报