/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

1 vote185 views1 answer
Delete triger pl pg sql
SQL
1 vote258 views1 answer
How to put value in variable mysql
SQL
1 vote194 views1 answer
Sqlalchemy order_by
SQL
13 votes197 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote203 views1 answer
Get rows from 1 table with other table empty mysql
SQL
0 vote206 views1 answer
Postgres statistics
SQL
0 vote189 views1 answer
Mysql update sum same table
SQL
5 votes213 views1 answer
Sql table columns
SQL
0 vote210 views1 answer
T sql dynamic top n query
SQL
2 votes209 views1 answer
Use cases condition in sql query laravel
SQL