/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

2 votes109 views2 answers
Postgresql date at timezone
SQL
0 vote157 views1 answer
Sql pivot table
SQL
0 vote100 views1 answer
Possgress drop if exists view
SQL
0 vote125 views1 answer
Postgresql create query
SQL
0 vote153 views2 answers
Sql update multiple tables
SQL
1 vote133 views2 answers
Drop table with constraints
SQL
0 vote112 views1 answer
Mysql match in serialized data
SQL
0 vote138 views1 answer
Space not removing from column in sql
SQL
3 votes137 views1 answer
Sql several or
SQL
1 vote108 views1 answer
Floor function in sql oracle
SQL