/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

8 votes226 views1 answer
Oracle add months to sysdate
SQL
5 votes230 views1 answer
JBDC
SQL
0 vote229 views1 answer
Guid string to binary better
SQL
0 vote238 views1 answer
Create function in microsoft sql server
SQL
0 vote229 views1 answer
How to add boolean column in postgresql
SQL
0 vote231 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
0 vote227 views1 answer
Sintaxis SELECT sql
SQL
2 votes227 views1 answer
How to create sql database
SQL
0 vote255 views1 answer
Wp_query raw sql
SQL
1 vote240 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL