/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 vote327 views1 answer
Difference between cross apply and inner join
SQL
0 vote304 views1 answer
Mysqli or pdo
SQL
2 votes378 views1 answer
Metasploit start postgresql
SQL
0 vote384 views1 answer
Openquery update linked server
SQL
27 votes364 views5 answers
Add column in table
SQL
1 vote366 views1 answer
Add many column to sap iq table
SQL
0 vote341 views1 answer
Get record which is available in one table but not in another mysql
SQL
23 votes358 views4 answers
Sql server substring
SQL
0 vote345 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
22 votes347 views4 answers
Mysql date format
SQL