select a.name as colname, b.name as typename from syscolumns a, systypes b where a.xusertype=b.xusertype and a.id=object_id('表名')