/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 vote140 views1 answer
Duplix print in Smartforms
SQL
1 vote148 views2 answers
Mysql error 1215
SQL
0 vote123 views1 answer
Join creating duplicate columns sqllite
SQL
0 vote143 views1 answer
Select new table sql
SQL
12 votes135 views5 answers
Rename table in mysql
SQL
0 vote173 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
-1 vote132 views1 answer
Export mysql table to file
SQL
0 vote143 views1 answer
Postgresql select fast check no rows
SQL
2 votes121 views1 answer
Convert series number to date in sql
SQL
2 votes176 views1 answer
Oracle Column Names of a table
SQL