Source:
https://www.thepolyglotdeveloper.com/2015/01/find-tables-oracle-database-column-name/
Depending on your access you will use one of the following queries:
-- Standard Users
select table_name from all_tab_columns where column_name = 'PICK_COLUMN';
-- DBA Users
select table_name from dba_tab_columns where column_name = 'PICK_COLUMN';
-- Just want to see what table looks like
describe namespace.tableName
If you want some database tool here are ones I like. I usually go for the ‘kitchen sink’ toolsets:
- DBeaver – https://dbeaver.io/
- Database .NET – https://fishcodelib.com/Database.htm
- Database Browser –
https://www.etl-tools.com/database-browser/overview.html
Updated 5/15 – Add looking for column in a known table
SELECT *
FROM all_tab_columns
WHERE table_name = 'MyTableName'
ORDER BY COLUMN_ID;