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='字段名'
转载于:https://www.cnblogs.com/chenh/p/10411406.html