All_tab_columns

Find Tables Containing a Specific Column in Oracle Database Purpose Which tables in this database have a column called CUSTOMER_ID? Sooner or later every DBA or developer needs the answer. The DBA_TAB_COLUMNS view lists the columns of every table, view, and cluster in the database. One query against it returns each …