/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 vote381 views1 answer
Postgres grep entire database
SQL
0 vote379 views1 answer
Migration graphql
SQL
1 vote373 views1 answer
Psql connections
SQL
9 votes343 views2 answers
Default number in sql
SQL
0 vote376 views1 answer
Inserting data into different tables at once in oracle sql
SQL
0 vote404 views1 answer
Combine 2 columns search query mysql
SQL
0 vote390 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
0 vote346 views1 answer
Psql check if value in array
SQL
2 votes344 views1 answer
Oracle cpu per session
SQL
2 votes355 views3 answers
Oracle show column of table
SQL