I want to find out primary,fk, and all constraints defined on table in oracle we can use desc table name,?

  • Interview Candidate
  • 3
  • 4176

Showing Answers 1 - 3 of 3 Answers

jitendraprajapati

  • Jan 25th, 2007
 

Try this --All PK and Constraints Select * from SYSCAT.COLUMNS;--All references (FK)Select * from SYSCAT.REFERENCES;

Regards,
Jitendra

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions