27,579
社区成员
发帖
与我相关
我的任务
分享
select 字段顺序='字段'+ltrim(colid),字段名=name from syscolumns where id=object_id('tb')
union all
select '合计',ltrim(count(1)) 统计数 from syscolumns where id=object_id('tb')
/*
字段顺序 字段名
---------- ------------------------------------
字段1 ID
字段2 WEBpage
合计 2
(3 行受影响)
*/
--2005
select name from sys.columns where object_id=object_id('表名')
select max(column_id) from sys.columns where object_id=object_id('表名')
select name from syscolumns where id=object_id('表名')
select count(1) 统计数 from syscolumns where id=object_id('表名')