/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

1 vote122 views1 answer
Oracle avg
SQL
0 vote133 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
0 vote128 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote133 views1 answer
Enable sql server full text indexing
SQL
16 votes129 views3 answers
T-SQL Add Column
SQL
0 vote86 views1 answer
Flask_sqlalchemy install
SQL
0 vote147 views1 answer
Delete a temporary table mysql
SQL
1 vote120 views1 answer
Postgres get month name from date
SQL
0 vote143 views1 answer
Sql describe
SQL
2 votes130 views2 answers
Spring where to put the data sql
SQL