Create a gist now

Instantly share code, notes, and snippets.

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'

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