/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 vote267 views1 answer
Oracle list of long running queries
SQL
0 vote279 views1 answer
WHERE not regex in SQL
SQL
0 vote264 views1 answer
Drop column from local database postgres pgadmin
SQL
0 vote296 views2 answers
Generate sql trigger through ef migration
SQL
0 vote273 views1 answer
Delete first row in sql
SQL
3 votes290 views1 answer
Laravel paginate raw sql
SQL
0 vote209 views1 answer
Testing sql queries
SQL
0 vote289 views1 answer
Consecutive numbers sql
SQL
0 vote278 views1 answer
Mariadb disable foreign key checks
SQL
1 vote297 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL