/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 vote206 views1 answer
Pl/pgsql declare variable
SQL
0 vote177 views1 answer
Min and max salary and name in sql
SQL
1 vote188 views1 answer
Rename table column name in mysql
SQL
0 vote185 views1 answer
Sql query for displaying age from oldest to youngest
SQL
4 votes197 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote196 views1 answer
Replace divide by zero error with 0 in sql
SQL
2 votes205 views2 answers
Install postgresql
SQL
12 votes311 views2 answers
Find duplicates mysql column
SQL
11 votes183 views2 answers
Insert current date sql
SQL
17 votes247 views6 answers
Get last record in sql
SQL