/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

31 votes204 views3 answers
Sql count(*)
SQL
0 vote230 views1 answer
Convert LDAP Epoch to Date
SQL
5 votes209 views3 answers
Mysql check if null or empty string
SQL
0 vote217 views1 answer
Show database not empty tables postgres
SQL
0 vote234 views1 answer
Add mysql database to power bi web
SQL
0 vote208 views1 answer
Create new schema mysql
SQL
0 vote191 views1 answer
Mysql workbench search all tables
SQL
0 vote221 views1 answer
Oracle sql number to varchar2
SQL
0 vote221 views1 answer
Write sql query to show the details start from digit
SQL
2 votes210 views3 answers
3 days back in sql server
SQL