Instantly share code, notes, and snippets.

Embed
What would you like to do?
Show all tables that have a specific column name (Oracle)
SELECT TABLE_NAME FROM USER_TAB_COLUMNS
WHERE COLUMN_NAME = 'ID'
@arianmaykon

This comment has been minimized.

arianmaykon commented Apr 10, 2012

Maybe you can find some commands here https://gist.github.com/1104227 :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment