Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    93

    Unanswered: how to find a field in a db when u don;t know the table?

    I need to find a field in a database but I don;t know which table it is?

    I have tried, select * from dictionary to find the right table, a
    also tried
    select * from all_updatable_columns
    or select * from dba_tables
    or select * from user_tables, but none of these give are given me 'data' information?

    any ideas?
    Cheers
    Etravels

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    If you know the column_name ...

    select table_name from user_tab_columns where column_name = 'columnname';

    HTH
    Gregg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •