sqlserver统计一张表字段数量，sqlserver列出表所有字段

统计表中字段的个数
select
a.name
,count(0) 字段总数
from
sys.objects a
inner join sys.all_columns b on a.object_id=b.object_id
where
a.type=‘U’ and a.name=‘表名’
group by
a.name

列出所有的表字段

1.每个字段一行
SELECT c.name AS ColumnName
FROM sys.columns c
INNER JOIN sys.types t ON c.user_type_id = t.user_type_id
INNER JOIN sys.tables tb ON c.object_id = tb.object_id
WHERE tb.name = ‘表名’;

2.将所有字段在一行中列出
SELECT STUFF((
SELECT ‘, ’ + COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ‘表名’
FOR XML PATH(’‘), TYPE).value(’.', ‘NVARCHAR(MAX)’), 1, 2, ‘’) AS ColumnsList;