Modify the schema SQL of database tables in batches

Sometimes I forget to select the owner when I import and export the database username. At this time, this SQL is used.

Declare @ name sysname -- table name variable declare csr1 cursor -- Define a cursor for select name from sysobjects where xtype = 'U' -- get table name open csr1declare @ schematable varchar (200) fetch next from csr1 into @ namewhile (@ fetch_status = 0) Begin set @ name = 'old architecture. '+ @ name print 'alter schema DBO transfer' + @ name -- Here DBO is the new architecture, remember to modify set @ schematable = 'alter schema DBO transfer '+ @ name -- execute the statement exec (@ schematable) -- start fetch next from csr1 into @ name -- cyclic cursor value endclose csr1 --- Close the cursor deallocate csr1