/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 vote316 views1 answer
Safe mysql
SQL
0 vote407 views1 answer
Mysql get nested records
SQL
0 vote410 views1 answer
Current month transactions in mysql
SQL
1 vote364 views2 answers
Truncate table sqlite
SQL
2 votes351 views3 answers
Mysql pass command from command line
SQL
0 vote329 views1 answer
Select multiple row from primary key sql
SQL
0 vote347 views2 answers
Mysql update two tables at once
SQL
1 vote310 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote355 views1 answer
Hibernate dialect property xml for mysql 8
SQL
1 vote350 views1 answer
Mysql print variable
SQL