Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE your_db_name
- DECLARE schema_table CURSOR FOR
- SELECT
- t.name AS table_nm,
- s.name AS schema_nm
- FROM
- sys.tables t inner join sys.schemas s ON t.schema_id = s.schema_id
- WHERE
- s.name = 'offending schema name'
- ORDER BY
- t.name
- DECLARE @tbl_nm nvarchar(50),
- @sch_nm nvarchar(50)
- OPEN schema_table
- FETCH NEXT FROM schema_table INTO @tbl_nm, @sch_nm
- WHILE @@FETCH_STATUS = 0
- BEGIN
- EXEC('ALTER SCHEMA dbo TRANSFER ' + @tbl_nm)
- FETCH NEXT FROM schema_table INTO @tbl_nm, @sch_nm
- END
- CLOSE schema_table
- DEALLOCATE schema_table
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement