Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

find tables with column name in sql

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
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #find #tables #column #sql
ADD COMMENT
Topic
Name
9+4 =