sql-server-2008 - 计算 SQL Server 中的列数

Question

有没有办法知道 SQL 中的列数，比如 count()...？

Answer 1

单程

select count(*) from sys.columns 

其他

select count(*) from information_schema.columns

最底层没有系统表

按表

select count(*),table_name from information_schema.COLUMNS
GROUP BY table_name

仅表

select count(*),c.table_name 
from information_schema.COLUMNS c
JOIN information_schema.tables t ON c.TABLE_NAME = t.TABLE_NAME
AND c.TABLE_Schema = t.TABLE_Schema
WHERE TABLE_TYPE = 'base table'  
GROUP BY c.table_name

仅查看

select count(*),c.table_name 
from information_schema.COLUMNS c
JOIN information_schema.tables t ON c.TABLE_NAME = t.TABLE_NAME
AND c.TABLE_Schema = t.TABLE_Schema
WHERE TABLE_TYPE = 'view'  
GROUP BY c.table_name