MSSQL 2012 修改所有表的架构Schame

ALTER SCHEMA [dbo] TRANSFER [sq_szswdjd].COM_Category

DECLARE @name VARCHAR(30);

declare csr1 cursor

      for

      select 'Name' = name

      from sysobjects

      where USER_NAME(uid)='sq_szswdjd'

      order by name;

      open csr1       --循环读取游标记录,执行系统存储过程SP_ChangeObjectOwner修改对象所有者

      FETCH NEXT FROM csr1 INTO @name

      while (@@FETCH_STATUS=0)

      BEGIN

      SET @name='sq_szswdjd.'+@name

      PRINT 'ALTER SCHEMA [dbo] TRANSFER '+@name+';';

      fetch next from csr1 into @name

      END

      CLOSE csr1;