Not logged in - Login
< back

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'