/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 vote109 views1 answer
Mysql select where field like in list
SQL
2 votes113 views2 answers
Postgres set user as superuser
SQL
20 votes118 views5 answers
Reset auto increment mysql
SQL
0 vote110 views1 answer
Install sql server in ubuntu 20.04
SQL
0 vote116 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
0 vote131 views2 answers
Plpgsql
SQL
0 vote103 views1 answer
How to connect pgadmin with excel
SQL
0 vote114 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote152 views1 answer
Sql server datetime
SQL
0 vote126 views2 answers
Mysql row_number() example
SQL