Solved

What's the differnce between xtype and xusertype in systypes

Posted on 2008-09-29
4
1,611 Views
Last Modified: 2010-04-21
What's the differnce between xtype and xusertype in systypes?
It seems that they are the same for all types except "sysname"
0
Comment
Question by:treehouse2008
  • 2
  • 2
4 Comments
 
LVL 11

Expert Comment

by:aaronakin
ID: 22597551
Here's is a description of the two from microsoft.  http://msdn.microsoft.com/en-us/library/ms175109(SQL.90).aspx
0
 

Author Comment

by:treehouse2008
ID: 22597893
I read that before.  I do not understand what's "Physical storage type" and "Extended user type". And how xtype and xusertype are used in differnt situations?
0
 
LVL 11

Accepted Solution

by:
aaronakin earned 250 total points
ID: 22600733
If you have any user-defined datatypes, they all have an underlying system type tied to them.  For instance, the user type PhoneNumber could have a system type of char(10).  In this case, the xtype value would be the id for the varchar type, and the xusertype value would be the id for the PhoneNumber type.
0
 

Author Closing Comment

by:treehouse2008
ID: 31501228
Thanks
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to shrink a transaction log file down to a reasonable size.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now