Oracle:
select TABLE_NAME from dba_tab_columns where s.column_name='字段名';
select TABLE_NAME from user_tab_columns where s.column_name='字段名';
注意:字段名必须大写
MSSql:
SELECT t2.name FROM syscolumns t1,sysobjects t2 WHERE t1.id=t2.id and t1.NAME='字段名'
Oracle:
select TABLE_NAME from dba_tab_columns where s.column_name='字段名';
select TABLE_NAME from user_tab_columns where s.column_name='字段名';
注意:字段名必须大写
MSSql:
SELECT t2.name FROM syscolumns t1,sysobjects t2 WHERE t1.id=t2.id and t1.NAME='字段名'