1. dbherron New Member

   What's the difference between the xtype and type column. Is xtype Microsoft only and type would be the more cross platform type?
   
   cSharp

   dbherron, Dec 14, 2004

   #2
2. x002548 New Member

   BOL say they are the same.
   
   Ever look at INFORMATION_SCHEMA.Columns?
   
   
   
   
   
   Brett
   
   

   x002548, Dec 14, 2004

   #2
3. satya Moderator

   We can use xtype column in sysobjects table to get useful database information. This column specifies the type for the row entry in sysobjects.
   
   And as advised only use INFORMATION_SCHEMA views for system information which is a good practice.
   
   Satya SKJ
   Moderator
   http://www.SQL-Server-Performance.Com/forum
   This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

   satya, Dec 15, 2004

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in