/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

3 votes251 views1 answer
Oracle get trigger ddl
SQL
0 vote259 views2 answers
How to tun mysql on ubunto
SQL
3 votes240 views2 answers
Oracle sql drop sequence
SQL
0 vote249 views1 answer
Insert thai language sql server
SQL
10 votes275 views2 answers
Mysql remove only_full_group_by permanently
SQL
0 vote249 views1 answer
Postgresql find missing id
SQL
3 votes270 views2 answers
Sql server current date without time
SQL
6 votes249 views1 answer
Allsource oracle
SQL
1 vote270 views1 answer
Drop column if exists sql server
SQL
0 vote264 views2 answers
Suse stop MySQL
SQL