sql2005导入数据库后,如何修改表的架构

批量修改表框架：declare @name sysnamedeclare csr1 cursorfor select TABLE_NAME from INFORMATION_SCHEMA.TABLESopen csr1FETCH NEXT FROM csr1 INTO @namewhile (@@FETCH_STATUS=0)BEGINSET @name=旧架构名称.' + @nameprint 'ALTER SCHEMA dbo TRANSFER ' + @namefetch next from csr1 into @nameENDCLOSE csr1DEALLOCATE csr1