Home » SQL & PL/SQL » SQL & PL/SQL » How to know what are the constraints defined on a table?
How to know what are the constraints defined on a table? [message #324819] Wed, 04 June 2008 03:56 Go to next message
renu4dwh
Messages: 24
Registered: April 2008
Location: Pune
Junior Member
What will be the query to find out what are the constraints already defined on a table?

Second thing i want to know is, what is the use of NOVALIDATE parameter while specifying a constraint.

Thanks.
Re: How to know what are the constraints defined on a table? [message #324821 is a reply to message #324819] Wed, 04 June 2008 04:06 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ USER/ALL/DBA_CONSTRAINTS

2/ Contraints

Regards
Michel
Previous Topic: Problem: Run schedular to copy from one table to other
Next Topic: Problem: Do I need to use materialized view for this?
Goto Forum:
  


Current Time: Thu Dec 08 16:06:44 CST 2016

Total time taken to generate the page: 0.06394 seconds