Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

If i want to transfer schema ownership to another schema i know that i need to use something like:

ALTER SCHEMA destinationschema TRANSFER sourceschema.objectname;

But how is it different from:

ALTER AUTHORIZATION ON OBJECT::sourceschema.objectname TO destinationschema ;

Thanks in advance!

share|improve this question
up vote 7 down vote accepted
  • ALTER AUTHORIZATION has a more general use for changing ownership of databases, types, keys etc. There is an ENDPOINT example n this MSDN link

ALTER AUTHORIZATION can be used to change the ownership of any entity that has an owner

Transfers a securable between schemas

In this special case you've highlighted, they do the same thing, There is no difference.

I'll guess that ALTER SCHEMA was added for completeness (eg there is CREATE and DROP why not ALTER) or in preparation for other features (such as renaming a SCHEMA, say)

share|improve this answer
Thank you very much! :-) – Manjot May 10 '11 at 19:51

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.