1)run
SELECT 'ALTER SCHEMA dbo TRANSFER ' + TABLE_SCHEMA + '.' + TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'your current schema name'
2)copy query result , paste to query window and run
change db userprefix schema to dbo
mikebai
This person is a lazy dog and has left nothing