sql server 2005修改表的架构

在SQL Server 2005中批量修改表的架构,执行以下SQL，将执行结果拷贝出来，批量执行既可。

declare @name sysname
declare csr1 cursor
for 
select TABLE_NAME from INFORMATION_SCHEMA.TABLES
open csr1

FETCH NEXT FROM csr1 INTO @name
while (@@FETCH_STATUS=0)
BEGIN
SET @name='旧的架构名称.' + @name

print 'Alter SCHEMA dbo TRANSFER ' + @name
fetch next from csr1 into @name
END
CLOSE csr1
DEALLOCATE csr1

------------执行结果如：----------
Alter SCHEMA dbo TRANSFER cwb4129.tbl_sellbuy2
Alter SCHEMA dbo TRANSFER cwb4129.tbl_outsourcing
Alter SCHEMA dbo TRANSFER cwb4129.tbl_sellbuy
Alter SCHEMA dbo TRANSFER cwb4129.tbl_directory
Alter SCHEMA dbo TRANSFER cwb4129.tbl_company2
Alter SCHEMA dbo TRANSFER cwb4129.tbl_count
Alter SCHEMA dbo TRANSFER cwb4129.tbl_company
Alter SCHEMA dbo TRANSFER cwb4129.tbl_code
Alter SCHEMA dbo TRANSFER cwb4129.tbl_ad
Alter SCHEMA dbo TRANSFER cwb4129.smt_xxnewssort_vip
Alter SCHEMA dbo TRANSFER cwb4129.SMT_xxnewssort
... ... ...

然后将这个结果再执行一遍即可。
参考地址：http://hi.baidu.com/thunten/blog/item/c39e0caf2e00fa034a36d603.html