/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

4 votes114 views1 answer
Search column by name mysql
SQL
0 vote112 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
0 vote130 views1 answer
Sql period overlap
SQL
0 vote127 views1 answer
Sql query for getting data with join and count
SQL
3 votes128 views1 answer
How to find names includes in sql
SQL
1 vote146 views2 answers
End mysql command
SQL
0 vote133 views1 answer
Ver usuarios mysql
SQL
0 vote137 views2 answers
How to get last inserted id in sql server c#
SQL
33 votes129 views6 answers
Sql delete
SQL
0 vote242 views1 answer
Install mysql on bash
SQL