/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

37 votes340 views3 answers
Sql check duplicate value in column
SQL
1 vote144 views1 answer
Give a column name to values generated from case statement in sql
SQL
6 votes235 views3 answers
Psql show columns of table
SQL
3 votes149 views3 answers
Stop mysql service ubuntu
SQL
0 vote155 views1 answer
Tsql table column constraint must be uppercase
SQL
7 votes147 views1 answer
Mysql remote connection command line
SQL
0 vote160 views1 answer
Mysql into outfile with headers
SQL
4 votes142 views2 answers
Oracle unlock user
SQL
3 votes139 views1 answer
Select nextval from sequence sql
SQL
0 vote182 views1 answer
Ceil upto 2 decimal place mysql
SQL