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

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.