/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

5 votes368 views1 answer
Ora-00054 find lock
SQL
0 vote375 views1 answer
Check if a column is a primary key in sql server
SQL
0 vote362 views1 answer
Oracle sql count occurrences of value in column
SQL
-3 votes451 views8 answers
Sql to c# linq converter online
SQL
0 vote374 views1 answer
Select a row include list of array with join table SQL
SQL
27 votes372 views5 answers
Add column in table
SQL
0 vote353 views1 answer
Many rows to 1 string mysql
SQL
0 vote351 views1 answer
Zerar auto increment mysql
SQL
5 votes422 views3 answers
Sql limit offset
SQL
0 vote397 views1 answer
Order child below the parent in mysqli
SQL