Wednesday, February 13, 2013

Oracle : Finding tables with given column name

One of my colleague today come to me asking where  can i find this column (LANDING_PAGE) in DB of our application. Actually he was not even sure of the column name. It was a field in UI. Our application has more than 200 tables and my tables are heavy (having many columns). So human search was futile. Thankfully there is a query in oracle which came to rescue.

select * from user_tab_columns where column_name like '%PAGE%';

No comments: