/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

2 votes111 views1 answer
Mariadb select multiple rows into one column
SQL
3 votes110 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
-1 vote77 views1 answer
Mysql if example
SQL
0 vote96 views2 answers
SQL Server Standard
SQL
-1 vote114 views1 answer
Add bool column in sql
SQL
0 vote152 views1 answer
Python mysql check if database exists
SQL
3 votes168 views1 answer
Mysql group_concat distinct
SQL
0 vote114 views1 answer
Datatables server side filter where clause
SQL
8 votes100 views3 answers
Alter user root mysql
SQL
0 vote112 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL