SQL Server Performance Forum – Threads Archive
xtype/type in sysobjectWhat’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
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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.