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.

Example

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

__________________
The KINGMAKER
Makes Every Thing Possible

Stuffs (My Blog)