Question

怎么通过一个sql语句查询一个表中字段的个数

Answer 1

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
修改逗表名地为实际需要查询的表名即可

Answer 2

select
a.name,b.name
from
sys.columns
as
a
join
sys.types
as
b
on
a.system_type_id=b.system_type_id
where
object_id=(select
object_id
from
sys.tables
where
name='表的名字')