--ALTER USER dbo WITH DEFAULT_SCHEMA =cn17010; --alter schema dbo TRANSFER cn17010.srchannel -- --ALTER SCHEMA slqwell TRANSFER create table #t ( ID int IDENTITY (1,1) not null, --创建列ID,并且每次新增一条记录就会加1 procName varchar(100), ) insert into #t(procName) select 'cn17010.' +name from sysobjects where xtype='U' and status>=0 --如果是存储过程xtype='P' --select * from #t declare @i int declare @j int set @j = 1 select @i=count(1) from #t declare @procName varchar(100) declare @SchemaTable varchar(200) while(@j < (@i + 1)) begin select @procName=procName from #t where ID=@j set @j = @j + 1 set @SchemaTable = 'ALTER SCHEMA dbo TRANSFER ' + @procName exec (@SchemaTable) end drop table #t
更新架构
最新推荐文章于 2024-12-26 20:03:46 发布