Thursday, May 17, 2012

Find which table has a particular column in Oracle

Sometimes we need to find out which tables contain a particular column. In Oracle this can be simply done by querying the DBA_TAB_COLUMNS system table:
SELECT * FROM DBA_TAB_COLUMNS WHERE COLUMN_NAME = 'ACME';
Post a Comment