select count(1) from syscolumns where id = object_id(‘tbname‘) 或者 select * from syscolumns where id = object_id(‘tbname‘) 或 SELECT MAX(colid) FROM syscolumns WHERE id=OBJECT_ID(‘table‘)
SQL SERVER 查询一个表有多少列
原文：http://www.cnblogs.com/ShaYeBlog/p/4246562.html
