select name from syscolumns where id=object_id('表名')
select count(1) 统计数 from syscolumns where id=object_id('表名'
还是要整在一个表:
-
SQL code
-
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