Brian Cryer

 

Cry How To...


List all tables that contain a given column name


To list all tables that contain a given column name:

select sysobjects.name, * from syscolumns, sysobjects
where syscolumns.name='column-name'
and sysobjects.id = syscolumns.id
and (sysobjects.xtype='U' or sysobjects.xtype='S')
and sysobjects.name like 'sys%'

These notes have been tested with Oracle 9 under Windows XP.

This page represents one page of many pages of notes I made whilst working with Oracle 7 through to 10i. I now no longer work with Oracle databases, but hope that these notes will continue to be of benefit to others.



About the author: is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.