homepage Welcome to WebmasterWorld Guest from 54.204.94.228
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

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




msg:1580725
 4:09 pm on Feb 2, 2006 (gmt 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?

 

zCat




msg:1580726
 4:25 pm on Feb 2, 2006 (gmt 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'

SEOViking




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

thanks zCat! it worked =)

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved