如何用sql得到某个表的各个字段名称，

[sunrise10]

如题

[hjb111]

sp_table 'yourtable'

select a.name from syscolumns a,sysobjects b where a.id=b.id and b.name='yourtable'

[zclxyh]

select a.name from syscolumns a,sysobjects b where a.id=b.id and b.name='表名'

[hjb111]

sp_tables 'yourtable'

[hjb111]

应当是sp_columns 'yourtable'

[txlicenhe]

sp_columns 'yourTable'
or
select * from syscolumns

不过我一般用这个视图
Create view fielddesc
as
select o.name as oname, c.name as cname,convert(varchar(30),p.value) as value,p.smallid as psmallid,t.name as tname
from syscolumns c
join systypes t on c.xtype = t.xtype
join sysobjects o on o.id=c.id
left join sysproperties p on p.smallid=c.colid and p.id=o.id
where o.xtype='U'

[happy_0325]

EXEC sp_columns @table_name = 'customers'