Find column name in tables select table_name from all_tab_columns where column_name='THE_COLUMN_YOU_LOOK_FOR';