/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 vote349 views1 answer
Enable sql server full text indexing
SQL
4 votes343 views2 answers
Select first and last row mysql
SQL
42 votes447 views6 answers
Rename table sql server
SQL
0 vote344 views1 answer
Selecting all columns from table sql database
SQL
0 vote368 views1 answer
Psql store procedure-return multiple table values
SQL
1 vote331 views1 answer
Increase existing date in sql oracle
SQL
3 votes316 views1 answer
Difference sql vs mysql
SQL
0 vote368 views1 answer
Postgresql inheritance
SQL
0 vote351 views1 answer
How to make full text search dynamic in mysql
SQL
1 vote331 views1 answer
Mysql select another database
SQL