/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 vote242 views1 answer
Random name function in mysql for nvarchar
SQL
0 vote264 views1 answer
Show all sequences postgres
SQL
0 vote224 views1 answer
How get data from database if id not found then search another column
SQL
0 vote255 views1 answer
Show specific events on mysql
SQL
7 votes263 views5 answers
Max 3 salary in sql
SQL
0 vote228 views3 answers
Find below average salary in sql
SQL
0 vote213 views1 answer
Java mysql date format
SQL
0 vote242 views1 answer
Get primary key of table
SQL
2 votes240 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
6 votes227 views2 answers
Mysql check auto increment value
SQL