Welcome to WebmasterWorld Guest from 50.17.117.221

Forum Moderators: open

Message Too Old, No Replies

Oracle SQL*Plus - how do i list all tables containing column name 'id'

     
4:09 pm on Feb 2, 2006 (gmt 0)

Junior Member

10+ Year Member

joined:Oct 29, 2004
posts:49
votes: 0


Anyone know how to list/print out all table names that contain the column name 'id', for example, in SQL*Plus from an Oracle 8i database?
4:25 pm on Feb 2, 2006 (gmt 0)

Preferred Member

10+ Year Member

joined:Oct 1, 2004
posts:607
votes: 0


'Fraid I haven't got an Oracle installation at hand right now, but this might work:

SELECT TABLE_NAME FROM USER_TAB_COLUMNS
WHERE COLUMN_NAME='id'

10:11 am on Feb 3, 2006 (gmt 0)

Junior Member

10+ Year Member

joined:Oct 29, 2004
posts:49
votes: 0


thanks zCat! it worked =)