SqlServer如何查询表的列数

Question

如题所述

Answer 1

select count(name) from syscolumns
where id=( select id from sysobjects where name='表名' and xtype='U')
说明：select id from sysobjects where name='表名' and xtype='U' 从sysobjects 里查询表类型为U(非系统)的表的id ，假设查到的是 1002 ；
select count(name) from syscolumns where id=1002 查的是系统列syscolumns 里表id是1002的列数。
你可以随便建个表，然后分步运行这两句看看

Answer 2

select count(*) from sysobjects a join syscolumns b
on a.id=b.id
where a.name='表名'本回答被提问者和网友采纳

Answer 3

select a.name as tablename,COUNT(1) as columncount from sysobjects a join syscolumns b
on a.id=b.id
where a.type='u' group by a.name

Answer 4

select o.name [表名称],c.name [列名称],* from sys.all_columns c left join sys.all_objects o on c.object_id=o.object_id
where o.type_desc like 'USER_TABLE'

Answer 5

select count(*) from 数据表名称;