Not logged in - Login

Change table schema to dbo

  1. SELECT 'ALTER SCHEMA dbo TRANSFER ' + TABLESCHEMA + '.' + TABLENAME FROM INFORMATIONSCHEMA.TABLES WHERE TABLESCHEMA = 'existing schema name'