/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

1 vote212 views1 answer
Oracle index partition
SQL
1 vote140 views1 answer
Python escape string for sql
SQL
-1 vote171 views1 answer
How to format tables in sqlplus
SQL
0 vote174 views2 answers
Mysql set foreign_key_checks=0
SQL
1 vote168 views1 answer
Select dba users oracle
SQL
0 vote187 views2 answers
Sql server select where date
SQL
0 vote295 views1 answer
Mysql edit trigger
SQL
2 votes193 views1 answer
Capitalize 1st letter in sql server
SQL
0 vote263 views1 answer
Oracle create package specification
SQL
0 vote209 views1 answer
Sql field equals multiple values
SQL