Alter schema on user-defined data type?
- From: David Walker <none@xxxxxxxx>
- Date: Fri, 11 Apr 2008 17:00:09 -0700
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.
It doesn't help to put the old schema name (dbo) in front of the type name.
Thanks for any help.
David Walker
.
- Follow-Ups:
- Re: Alter schema on user-defined data type?
- From: Erland Sommarskog
- Re: Alter schema on user-defined data type?
- Prev by Date: Re: Where are the permissions documented?
- Next by Date: Explicit permissions listed twice
- Previous by thread: Where are the permissions documented?
- Next by thread: Re: Alter schema on user-defined data type?
- Index(es):