记录一下。
SELECT table_name FROM USER_TAB_COLUMNS WHERE column_name = '字段名';
SELECT table_name FROM ALL_TAB_COLUMNS WHERE column_name = '字段名';
MSSQL
SELECT A.NAME 表名,B.NAME 列名
FROM SYSOBJECTS A,SYSCOLUMNS B
WHERE A.ID=B.ID
AND B.NAME='表名'
AND A.TYPE='U'