Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to know to what table a field belongs?
md9_at_ibest.com.br wrote:
> 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'
>
in SQLPLUS, try
DESCRIBE USER_TABLES Received on Tue Oct 19 2004 - 19:14:15 CDT