Question

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

我的数据库是sql server 2000

Answer 1

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

Answer 2

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

Answer 3

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

Answer 4

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

Answer 5

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