/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 vote107 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
0 vote115 views1 answer
Procedures sql insert mysql
SQL
0 vote132 views2 answers
Transaction php
SQL
9 votes111 views3 answers
Where in sql
SQL
1 vote159 views1 answer
Postgresql append array
SQL
1 vote156 views1 answer
Size of all tables in a schema oracle
SQL
0 vote109 views1 answer
Pgadmin see indexes
SQL
0 vote114 views2 answers
Update information in a mysql column
SQL
1 vote116 views1 answer
Oracle create program if no exists
SQL
12 votes111 views2 answers
Delete all data in neo4j
SQL