在数据库中查找某个字段属于哪个表的SQL语句怎么写

select [name] from sysobjects where id in(select id from syscolumns Where name='字段名')
这个是SQL Server 2000数据库！

select * from information_schema.columns where column_name=
'列名'
已测试~确实正确

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME='列名'

是MS-SQL吗？
在当前数据库中查找：
select object_name(id) as tablename from syscolumns where name = ...

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME='FOrderId'