Re: ** Help ** How to find.....

Bill Hayden wrote:
>
> MCC wrote:
> >
> > I need to analyze a table but cannot find the script that created the
> > table originally, how would I find the Primary key, Foreign key,
> > alternate key, indexes, and constraints of a table??
> >
> > Thank you for helping,
> > MCC
>
> It's all in the dictionary.....Use user(or all or dba)_constraints for
> keys and constraints and user_indexes, user_ind_columns for indexes.
>
> Bill
> --
> THE PRECEDING REFLECTS THE VIEWS OF THE AUTHOR
> AND NOT, NECESSARILY, THE VIEWS OF EDWARD JONES.
You can also do an export of that specific table, without data, and import it with list only.That will give you the table creation script and all the indexes,constraints,grants...

-- 
Michel Ouellet             - Email: ccmouem_at_cam.org
DBA                        - Tel: (514) 773-5041 x 281
Sport Maska Inc.  CCM      - St-Hyacinthe, Quebec.
--