Re: How to know to what table a field belongs?

<md9_at_ibest.com.br> wrote in message
news:75ba751c.0410191256.198b4b67_at_posting.google.com...
| Hi,
|
| I´m fixing a system made by another programmer,this system is very
| large and have no documentation at all.
|
| I want a command like this:
|
| select TABLE_NAME from USER_TABLES WHERE FIELD_NAME='PROJ_ID'
|
| Regards,
| Marcello Dias

very close... look at USER_TAB_COLUMNS or DBA_TAB_COLUMNS

++ mcs Received on Tue Oct 19 2004 - 17:15:00 CDT