SQL Server2005批量修改数据表的架构

declare @name sysname  
    declare @sql varchar(256)
    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='grid.' + @name  
    set @sql= 'ALTER SCHEMA tbobjects TRANSFER ' + @name  
    exec(@sql)
    fetch next from csr1 into @name  
    END  
    CLOSE csr1