/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 vote285 views1 answer
Date diff sql
SQL
3 votes309 views5 answers
Foreign keys
SQL
0 vote325 views1 answer
SQL Hello, [firstname] [lastname]
SQL
8 votes380 views3 answers
Find table for column name in sql
SQL
0 vote372 views1 answer
How to subquey to do not load in live database in
SQL
0 vote303 views1 answer
Mysql isshow
SQL
0 vote276 views1 answer
Oracle execute immediate quotes
SQL
0 vote307 views1 answer
Oracle for loop on list
SQL
0 vote305 views1 answer
Helptext in sql
SQL
6 votes284 views2 answers
Can't connect to local mysql server through socket
SQL