Blog from a software professional, Passionate to work in latest cutting edge technologies in order to get better results in business.
I am looking for a SQL to find in tables in which a Column is present. The following SQL was helpful:
SELECT TABLE_NAME, COLUMN_NAME FROM ALL_TAB_COLUMNS WHERE COLUMN_NAME LIKE '%COL X%'
Post a Comment
No comments:
Post a Comment