此文章主要向大家讲述的是批量更改SQL Server 2005的表架构的实际操作流程，我在一个信誉度很好的网站找到一个关于批量更改SQL Server 2005的表架构的实际操作流程的资料，拿出来供大家分享。
批量更改SQL Server 2005的表架构第一步：生成执行语句
view plaincopy to clipboardprint 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 新架构名 TRANSFER ' + @name fetch next from csr1 into @name END CLOSE csr1 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 新架构名 TRANSFER ' + @name fetch next from csr1 into @name END CLOSE csr1
批量更改SQL Server 2005的表架构第二步：执行上面命令生成的结果