SQL Change schema to dbo

Change schema to dbo on tables

Run this query on the DB

select 
      'ALTER SCHEMA dbo TRANSFER ' + sys.schemas.name + '.' + sys.tables.name
from 
      sys.tables inner join sys.schemas on sys.tables.schema_id=sys.schemas.schema_id

then run the results as query on the DB

(for example):

ALTER SCHEMA dbo TRANSFER IPICKAP_login.complete_tasks
ALTER SCHEMA dbo TRANSFER IPICKAP_login.Gallery