How do I change db schema to dbo
How do I change db schema to dbo
SELECT 'ALTER SCHEMA dbo TRANSFER ' + TABLESCHEMA + '.' + TABLENAME FROM INFORMATIONSCHEMA.TABLES WHERE TABLESCHEMA = 'jonathan'
How do I change db schema to dbo
SELECT 'ALTER SCHEMA dbo TRANSFER ' + TABLESCHEMA + '.' + TABLENAME FROM INFORMATIONSCHEMA.TABLES WHERE TABLESCHEMA = 'jonathan'