/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 vote271 views1 answer
Denied
SQL
0 vote400 views1 answer
Postgres extract number from string
SQL
10 votes330 views4 answers
Mysql one week ago
SQL
0 vote329 views1 answer
Mysql utc timestamp
SQL
2 votes392 views3 answers
Sql delete duplicate
SQL
0 vote281 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
0 vote341 views1 answer
Sql ignore
SQL
5 votes350 views2 answers
Mysqldump password
SQL
1 vote329 views1 answer
Psql client write to bash variable
SQL
1 vote357 views2 answers
Maximum number of tables in mysql
SQL