Xtype vs Type

What is the difference between xtype and type in sysobjects table.
PradeepYadhavAsked:
Who is Participating?
 
riaancorneliusConnect With a Mentor Commented:
pretty much the same thing. xtype gives slightly more detail. Example: In type you only have 'k' for all keys, but in xtype they broken into 'pk', 'fk', 'uq', etc...
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
xtype is a redundant extension  of type...
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
No difference, The system tables are used for internal purpose...
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
riaancorneliusCommented:
As a matter of interest, Why a grade of B?
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
From help section...

//
Grading at Experts Exchange is not like school. It's more like the "10-point Must" system in professional boxing; in other words, an answer is worth an A, unless it doesn't resolve your issue. If it requires you to do a little more research, or figure out one more piece of code, then it's worth a B. If you think it's not worth a B, the custom is to offer the Experts an opportunity to earn a better grade.
//
0
 
riaancorneliusCommented:
It's not a problem, just curious. I always check If it's not a grade of A, so that hopefully next time I can offer a better answer.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.