/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 vote336 views1 answer
Mysql DDL
SQL
0 vote349 views1 answer
Insert set mysql
SQL
0 vote314 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote329 views1 answer
Mysql database hyphen
SQL
3 votes309 views1 answer
Oracle nextval
SQL
0 vote326 views1 answer
T-SQL - Where Used List (Table/View)
SQL
0 vote354 views1 answer
Enable outgoing remote MySQL access
SQL
4 votes328 views3 answers
Create database in mySQL
SQL
1 vote326 views2 answers
Oracle list partitioned tables
SQL
8 votes362 views1 answer
Oracle current date plus 1 month
SQL