xtype/type in sysobject | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

xtype/type in sysobject

What’s the difference between the xtype and type column. Is xtype Microsoft only and type would be the more cross platform type? cSharp
BOL say they are the same. Ever look at INFORMATION_SCHEMA.Columns? Brett :cool:
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.
]]>