select count(1) from syscolumns where id = object_id('yourTableName'); 转载于:https://www.cnblogs.com/miclu/archive/2007/10/05/914686.html