/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 vote329 views1 answer
Check mysql password with docker container magento 2
SQL
0 vote372 views1 answer
Sql date between one week
SQL
2 votes350 views3 answers
3 days back in sql server
SQL
1 vote361 views3 answers
How to get date in sql
SQL
0 vote349 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
22 votes393 views3 answers
How to join three tables in sql using joins
SQL
0 vote351 views1 answer
Sql get user account
SQL
0 vote367 views1 answer
Sql file in postgres with pgadmin
SQL
0 vote376 views1 answer
How to find symmetric pairs in sql
SQL
1 vote329 views1 answer
Postgresql update auto_increment value
SQL