数据库查询字段的问题？

[yuan_1980]

我用 select name from syscolumns where id=object_id('TableName') 查询得到了字段名。我如何查询某一列呢？如我要查询第3个字段名！

[CrazyFor]

select name from syscolumns where id=object_id('TableName') and colid=X

[hjhing]

select name from syscolumns where id=object_id('TableName')
and colorder=3