Re: Alter schema on user-defined data type?

Erland Sommarskog <esquel@xxxxxxxxxxxxx> wrote in
news:Xns9A7E72BDABCDFYazorman@xxxxxxxxx:

David Walker (none@xxxxxxxx) writes:
SQL 2005: How do I alter the schema on a user-defined data type? Is
this possible?

When I try this:

Alter Schema NewSchemaName Transfer DescriptionType;

It fails with

Cannot find the object 'DescriptionType', because it does not exist
or you do not have permission.

While not documented, this seems to work:

Alter Schema NewSchemaName Transfer type::DescriptionType;

This syntax is available with other commands like ALTER AUTHORIZATION,
in which case it's also documented.


Ah! Thanks, I'll send that in as a doc update (I'll credit you with it).

David Walker
.