/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 vote291 views1 answer
Sql server alter table column nullable
SQL
0 vote326 views1 answer
Sql query inline if
SQL
8 votes294 views4 answers
How to calculate the age from date of birth in python
SQL
2 votes268 views1 answer
Oracle sql query to make column data uppercase
SQL
3 votes276 views1 answer
Oracle apex message quit website
SQL
-1 vote281 views1 answer
Add column alter table default value
SQL
0 vote287 views1 answer
Exec procedure oracle
SQL
0 vote276 views1 answer
Postgres call view
SQL
0 vote285 views1 answer
Remove transient options sql wordpress
SQL
2 votes303 views2 answers
Calculate percentage in sql
SQL