/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

3 votes128 views1 answer
Oracle revoke grant
SQL
1 vote137 views1 answer
How to check the mysql version mac
SQL
1 vote97 views2 answers
Get date from datetime postgresql
SQL
0 vote135 views1 answer
Database traccar
SQL
0 vote134 views1 answer
Dump only data
SQL
3 votes134 views1 answer
Force using index plsql
SQL
0 vote141 views1 answer
Ansi sql count duplicate rows
SQL
5 votes136 views2 answers
Oracle apex debug mode
SQL
5 votes152 views3 answers
Select tables from mysql database
SQL
27 votes145 views6 answers
Sql update record
SQL