如何查找表中某个字段的字段名？

[caterpillar54321]

比如说表table里面有
A、A1、A2、A3、B、B1、B2、C、C1、C2、C3几个字段，我该如何将这几个字段的字段名提取出来？？

[xiongjianxin520]

sql server :

Select name from syscolumns Where ID=OBJECT_ID('表名')

[wuyq11]

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

select * from syscolumns where ID =object_id('表名')

[xiaomeimei2009]

每个数据库的写法不一样 ，mssql的写法是：select b.name from sysobjects a,syscolumns b where a.id=b.id and a.name='表名'
<a href="http://www.51jidianhuan.com" target="_blank">详细信息</a>

[打一壶酱油]

select name from syscolumns Where ID=OBJECT_ID('表名')

[kid_wang]

select name from syscolumns where 
id=(
select max(id) from sysobjects where xtype='u' and name='表名'
)

[lz00728]

Select name from syscolumns Where ID=OBJECT_ID('表名')

过来学习