SELECT COUNT(syscolumns.name) FROM syscolumns , sysobjects WHERE syscolumns.id = sysobjects.id AND sysobjects.name = ‘表名‘
Sql 统计一个表有多少列
原文:http://www.cnblogs.com/mtsl/p/4232493.html