/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 vote314 views2 answers
How to combine diff colmun value using group by postgres
SQL
13 votes323 views2 answers
Get tables in database sql
SQL
-1 vote317 views1 answer
How to switch user in mysql
SQL
0 vote298 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
14 votes330 views2 answers
Install mysqldump
SQL
2 votes296 views1 answer
Sql find missing values between two tables
SQL
0 vote301 views1 answer
Back up stored procedures mysql
SQL
0 vote303 views1 answer
Tsql cmd exec script from file
SQL
0 vote347 views1 answer
Mysql dump with table query
SQL
2 votes327 views1 answer
Sql finding longest and shortest names in a fleld
SQL