/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 vote194 views1 answer
Mysql show schema
SQL
1 vote114 views2 answers
How to search date in sql query
SQL
0 vote112 views1 answer
Oracle flush Shared Pool
SQL
1 vote116 views1 answer
Floor function in sql oracle
SQL
0 vote117 views1 answer
Plpgsql raise notice
SQL
0 vote116 views1 answer
Multiple tricky query in sql server
SQL
0 vote123 views1 answer
Asp.net core sql server stored procedure
SQL
4 votes123 views3 answers
Postgres set default value
SQL
3 votes122 views1 answer
Fk in insert mysql
SQL
1 vote126 views1 answer
Get create table query existing table mysql
SQL