SQL Server Performance

xtype/type in sysobject

Discussion in 'T-SQL Performance Tuning for Developers' started by dbherron, Dec 14, 2004.

  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?

  2. x002548 New Member

    BOL say they are the same.

    Ever look at INFORMATION_SCHEMA.Columns?


  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
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page