SELECT *,
'ALTER AUTHORIZATION ON SCHEMA::' + QUOTENAME(SCHEMA_NAME) + ' TO db_owner;'
FROM INFORMATION_SCHEMA.SCHEMATA
WHERE SCHEMA_OWNER NOT LIKE 'db_%'
  AND SCHEMA_OWNER NOT IN ('INFORMATION_SCHEMA', 'sys', 'guest')