select name from syscolumns where id=object_id('表名') 或者 select b.name from sysobjects a,syscolumns b where a.id=b.id and a.name= '表名'