Sql 统计一个表有多少列 

 SELECT COUNT(syscolumns.name)
 FROM   syscolumns ,
        sysobjects
 WHERE  syscolumns.id = sysobjects.id
        AND sysobjects.name = '表名'

 

posted @ 2015-01-18 22:23  astrue  阅读(1221)  评论(0)    收藏  举报