/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 vote350 views1 answer
Mysql user set plugin
SQL
0 vote371 views2 answers
Fanyi
SQL
0 vote314 views1 answer
Sqlalchemy query return only n results
SQL
11 votes363 views1 answer
Oracle export view ddl
SQL
0 vote340 views1 answer
Wordpress database query change url
SQL
0 vote334 views1 answer
With_for_update sqlalchemy
SQL
0 vote282 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
1 vote323 views1 answer
Postgres convert exisiting column to text
SQL
1 vote348 views1 answer
Oracle insert multiple rows into same table
SQL
0 vote340 views1 answer
Postgres grep entire database
SQL