复制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.
喜欢
讨厌