SQL统计某张表的列数

SQL统计某张表的列数:

select count(syscolumns.name) 
from syscolumns , sysobjects 
where syscolumns.id = sysobjects.id 
and sysobjects.name = '表名'