/SQL/Oracle find all tables with column name

Oracle find all tables with column name

SELECT * FROM USER_TAB_COLUMNS WHERE COLUMN_NAME = 'MY_COLUMN'; -- Connected user
SELECT * FROM ALL_TAB_COLUMNS WHERE COLUMN_NAME = 'MY_COLUMN';	-- Other schemas
SELECT * FROM DBA_TAB_COLUMNS WHERE COLUMN_NAME = 'MY_COLUMN';	-- All tables

Oracle find all tables with column name

-- Oracle-specific
-- all_tab_columns is a magic table listing all columns from all tables
select table_name from all_tab_columns where column_name = 'PICK_COLUMN';

Source: thepolyglotdeveloper.com

Similar codes

0 vote206 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote189 views1 answer
Sqlite select split string
SQL
3 votes198 views1 answer
Insert into table from another table mysql
SQL
-1 vote195 views1 answer
Export mysql table to file
SQL
0 vote194 views1 answer
Get duplicate entry sql
SQL
0 vote237 views1 answer
Table structure in sql
SQL
0 vote185 views2 answers
How to get json data mysql
SQL
50 votes261 views6 answers
Sql duplicate rows
SQL
1 vote195 views1 answer
Sql order by where condition
SQL
0 vote184 views1 answer
Sql composite key
SQL