/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

0 vote277 views1 answer
Postgresql in vs any performance
SQL
0 vote297 views1 answer
How to find total working hour in sql
SQL
5 votes248 views1 answer
Mysql select greater than yesterday
SQL
5 votes271 views3 answers
Select tables from mysql database
SQL
0 vote290 views1 answer
Wordpress database query change url
SQL
1 vote253 views1 answer
Firebase bigquery cloud message
SQL
-1 vote273 views1 answer
Sql set max value in column
SQL
1 vote276 views1 answer
Postgres cast as currency format
SQL
0 vote320 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
1 vote484 views1 answer
Postgres convert text to number
SQL