/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 vote133 views1 answer
Top frequency in sql server
SQL
1 vote153 views1 answer
Spark sql convert string to date
SQL
1 vote186 views1 answer
Oracle previous year
SQL
0 vote143 views4 answers
Change schema in sql server
SQL
0 vote137 views1 answer
Change date in pivot table to month in sql server
SQL
0 vote150 views1 answer
Postgresql print variable
SQL
0 vote286 views1 answer
Hue hive UploadingTextFiletoHive
SQL
8 votes143 views2 answers
Sqlsrv default port
SQL
1 vote131 views1 answer
Oracle db create new schema
SQL
1 vote148 views1 answer
Oracle create index if not exists
SQL