Re: Few basic questions

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Wed, 8 Sep 1999 12:57:20 -0400
Message-ID: <7r65p8$rlf$1@winter.news.rcn.net>

Hi,

You will find the answers to your questions in the data dictionary.

look at:

user_indexes and users_ind_columns to get index information.

user_constraints and user_cons_columns for information about constraints

        user_dependencies for relationships between objects
        user_tables for information about your tables

There are several more user tables many of which are named "user_<object_type>. Examples of <object_type> are triggers, views, objects and synonyms

regards
Jerry Gitomer

CGS wrote in message ...
>Hi,
>
>I'm new to Oracle. I would like to how do I find out the primary
key and
>indexes on a given table? Does "DESC" command display these
information?
>How do I find all dependent objects like defaults, constraints
etc?
>
>Thanks in advance for your help.
>
>CGS
>tcgs_at_hotmail.com
>
>
>
Received on Wed Sep 08 1999 - 11:57:20 CDT