批量修改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 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.
本文地址：http://www.bzve.cn/html/522b9599382.html
版权声明
本文仅代表作者观点，不代表本站立场。
本文系作者授权发表，未经许可，不得转载。