/SQL/Find tables with column name in sql

Find tables with column name in sql

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

Similar codes

3 votes338 views1 answer
What is having
SQL
45 votes361 views5 answers
Grant all privileges mysql
SQL
7 votes346 views3 answers
Sql server check if temp table exists
SQL
4 votes273 views1 answer
SQL order random
SQL
3 votes301 views2 answers
Create schema postgres
SQL
0 vote242 views1 answer
Copy table dbeaver
SQL
0 vote309 views1 answer
Group by 15 minute interval sql server
SQL
0 vote288 views1 answer
Mysql shell set time_zone
SQL
-1 vote291 views1 answer
Count occurrences sql
SQL
3 votes313 views1 answer
Two select sql
SQL