/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 votes308 views2 answers
Mysql bidirectional composite primary key
SQL
4 votes282 views2 answers
Oracle unlock user
SQL
0 vote279 views1 answer
Sql period overlap
SQL
0 vote266 views1 answer
Show all mongodb
SQL
0 vote264 views1 answer
Mql5 list all available symbols
SQL
0 vote298 views1 answer
Psql show db
SQL
3 votes295 views1 answer
Mysql insert on dupèlicate
SQL
4 votes289 views4 answers
Date less than in sql
SQL
1 vote260 views2 answers
How to drop a unique constraint in sql
SQL
0 vote275 views1 answer
Postgres data location
SQL