SELECT a.name,b.name,c.name FROM sysobjects a join syscolumns b ON a.id=b.id join systypes c on b.xtype=c.xusertype AND a.type='u'