ALTER AUTHORIZATION

Change the ownership of an entity.

Syntax
      ALTER AUTHORIZATION ON [entity_type::] entity TO SCHEMA OWNER
      ALTER AUTHORIZATION ON [entity_type::] entity TO principal 

Key
   principal    The name of the principal that will own the entity

   entity_type  The class of the entity,
      one of:
          Database
          Schema
          XML Schema Collection
          Assembly
          Role
          Object    (table,view,function,procedure,queue,synonym)
          Fulltext Catalog
          Certificate
          Type
          Message Type
          Contract
          Service
          Remote Service Binding
          Route
          Symmetric Key
          Endpoint

You cannot change the owner of a system database (master, model, tempdb), the resource database, or any database that is used as a distribution database. The ownership of entity types not listed above cannot be transferred.

Examples

ALTER AUTHORIZATION ON OBJECT::tblParts TO BillG;
ALTER AUTHORIZATION ON tblCustomers TO MichikoOsada;
GO

"One of the healthiest ways to gamble is with a spade and a package of garden seeds” ~ Dan Bennett

Related commands

CREATE SCHEMA
CREATE USER

Equivalent Oracle commands:

Imp/Exp or Create.. As Select..