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';
No comments:
Post a Comment