Re: How can we list all the tables in a database?

From: Staffan Persson <stpe_at_secrc.abb.se>
Date: 1995/04/20
Message-ID: <3n5tui$6u4_at_sdaw04.seinf.abb.se>#1/1

In article <0098F119.1D21C47C_at_vms.csd.mu.edu>, 5603liul_at_vms.csd.mu.edu says...
>
>Dear netters:
>
> How can I know what tables I have in my databases?
>Thanks.
>
> David

You will find the information in the data dictionary view USER_TABLES and, if you are DBA, the DBA_TABLES

/Staffan Received on Thu Apr 20 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: John Strange: "Re: FORMS 3.0 Clear Field Question"
Previous message: Vish Gopalan: "Re: Oracle 7.1.4"
In reply to: 5603liul_at_vms.csd.mu.edu: "How can we list all the tables in a database?"
Next in thread: Frank Greene: "Re: How can we list all the tables in a database?"
Reply: Frank Greene: "Re: How can we list all the tables in a database?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message