sql 读取表的字段

select   a.[name]   from   syscolumns   a,sysobjects   b   where   a.id=b.id   and   b.id=object_id('表名')