表的列数 列名

列的数量 
select count(*)
From syscolumns
where id = object_id('table_name')

列名
Select * from INFORMATION_SCHEMA.columns　where table_name ='table_name'

aspnet2006 2.0 注册号

9302 7300123 3507890