/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 vote207 views1 answer
Sql change date format
SQL
0 vote315 views1 answer
Add user mysql wordpress
SQL
1 vote198 views1 answer
Sql server reseed single table
SQL
3 votes194 views2 answers
Find the median in sql
SQL
1 vote192 views1 answer
How to get mysql db size
SQL
3 votes254 views1 answer
Oracle nextval insert
SQL
0 vote207 views1 answer
Get rows from 1 table with other table empty mysql
SQL
3 votes228 views3 answers
Sql current year
SQL
0 vote200 views1 answer
MySQL INSERT IGNORE Statement
SQL
0 vote217 views1 answer
Is not sql
SQL