/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

4 votes275 views1 answer
Oracle user tables
SQL
0 vote293 views1 answer
Create tables from xsd to sql server database c#
SQL
0 vote232 views2 answers
Jupyter notebook connect to database
SQL
0 vote276 views2 answers
Drop check constraint in ms sql
SQL
0 vote281 views1 answer
Laravel eloquent get generated sql
SQL
1 vote275 views1 answer
Psql connect to another database
SQL
0 vote287 views1 answer
Sql server system messeges
SQL
0 vote320 views2 answers
Wordpress change url after migration mysql query
SQL
4 votes305 views1 answer
Data types in sql
SQL
1 vote273 views1 answer
Sql injection
SQL