/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 vote169 views1 answer
Display first three characters sql
SQL
10 votes180 views2 answers
Mysql remove only_full_group_by permanently
SQL
0 vote201 views1 answer
Install postgresql 12 on debian 10
SQL
0 vote173 views1 answer
Sqlite commands
SQL
5 votes154 views1 answer
Sql first day of current year
SQL
0 vote188 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
5 votes212 views1 answer
Oracle ora-00054 resource busy
SQL
0 vote171 views1 answer
Criteria builder select subset of column
SQL
2 votes174 views2 answers
Postgres add column integer
SQL
0 vote180 views4 answers
Open mysql port bitnami tomact
SQL