/SQL/Oracle find all tables with column name

Oracle find all tables with column name

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

Oracle find all tables with column name

-- Oracle-specific
-- all_tab_columns is a magic table listing all columns from all tables
select table_name from all_tab_columns where column_name = 'PICK_COLUMN';

Source: thepolyglotdeveloper.com

Similar codes

0 vote165 views1 answer
Oracle sql replace string in clob
SQL
0 vote178 views1 answer
Knex last insert id mysql
SQL
0 vote215 views1 answer
For row in sql database python loop
SQL
0 vote198 views1 answer
Windows services sql
SQL
6 votes199 views2 answers
Drop foreign key
SQL
0 vote244 views1 answer
Original Query
SQL
0 vote185 views1 answer
C# mysql update statement set value to null
SQL
2 votes195 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
2 votes247 views2 answers
Mysql search for column name in all tables
SQL
10 votes139 views1 answer
Oracle view dependencies
SQL