/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 vote315 views1 answer
Generate random data postgresql
SQL
11 votes312 views1 answer
Mysql text type max length
SQL
10 votes284 views2 answers
Mysql select timestamp group by day
SQL
1 vote325 views1 answer
Myql find duplicates
SQL
0 vote313 views1 answer
Normalization in database 2nd normal form
SQL
0 vote297 views1 answer
Sql get user account
SQL
1 vote324 views1 answer
Select users with same username
SQL
0 vote329 views1 answer
Make parameters nullable in sql server
SQL
8 votes330 views1 answer
Oracle add datafile to tablespace
SQL
0 vote330 views1 answer
Modifier une valeur sql
SQL