title: xtype vs type column in Sysobjects
body: <p>Can anyone tell me why <code>Sysobjects</code> table have two columns <code>xtype</code> and <code>type</code>. Both are of data type <code>char(2)</code> and stores the object type.</p>