关于查找字段的小问题，多谢了！在线等。。

[sk2002]

我想查找比如说数据库中哪个表中有category字段，该如何写SQL！

[pengdali]

select d.name from syscolumns a,sysobjects d where a.id=d.id and d.xtype='U' and a.name='category'

[zhbname]

select t1.name
from sysobjects t1,
syscolumns t2
where t1.id=t2.id
and t2.name='name'
and t1.xtype='U'
查找数据中表所含字段

[zjcxc]

select object_name(id) from syscolumns where name='category'

[zjcxc]

--还应该加上限制,仅表

select object_name(id) from syscolumns where name='category' and objectproperty(id,'IsUserTable')=1

[changechange]

select d.name from syscolumns a,sysobjects d where a.id=d.id and d.xtype='U' and a.name='category'