Re: Alter schema on user-defined data type?

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.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.