/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 vote188 views1 answer
Mysql edit trigger
SQL
0 vote106 views1 answer
Sql: extract day text from datetime value
SQL
0 vote99 views1 answer
How to fix mysql stop unexpectedly
SQL
0 vote132 views1 answer
Reset a table's identity column and remove test records
SQL
0 vote95 views1 answer
Full syntax inner join
SQL
0 vote115 views1 answer
Sqlite3 pragma foreign keys
SQL
1 vote121 views2 answers
Sql queries practice
SQL
0 vote103 views1 answer
Sort by last two number sql
SQL
0 vote111 views1 answer
Influxdb clone measurement
SQL
7 votes112 views1 answer
Query postgres delete duplicates
SQL